Question regardin replacing the value in a column

From: Praveen (nospam_at_spam.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 04:34:47 GMT

Hi..All,

    DB : Oracle 8i

I have a column in a table which is of type varchar. It can contain
characters like &, <, > etc along with all other characters.

now, I want to replace them with some other characters when I select the
column

& to &amp;
< to &lt;
> to &gt;

for eg if the column had the value <pass & fail>

when I execute the SQL
select column from table; I should get &lt;pass &amp; fail&gt;

I do I write one single SQL to achieve this.

Regards,

P

Relevant Pages

  • Re: Password Complexity Requirements in Windows 2008 Environment
    ... Best Regards. ... That's the mimimum but better use at least 8 characters as a minimum. ... The mimimum characters for password complexity are 7 not 3. ... The Password Complexity Policy is enabled in Default Domain ...
    (microsoft.public.windows.server.active_directory)
  • Re: Password Complexity Requirements in Windows 2008 Environment
    ... Best Regards. ... That's the mimimum but better use at least 8 characters as a minimum. ... This posting is provided "AS IS" with no warranties, ... The Password Complexity Policy is enabled in Default Domain Policy ...
    (microsoft.public.windows.server.active_directory)
  • Re: Password Complexity Requirements in Windows 2008 Environment
    ... Best Regards. ... That's the mimimum but better use at least 8 characters as a minimum. ... The mimimum characters for password complexity are 7 not 3. ... The Password Complexity Policy is enabled in Default Domain ...
    (microsoft.public.windows.server.active_directory)
  • Re: Need help on reading files in pocket pc in lesser time
    ... with about 100 characters per line) in 15 seconds. ... Windows CE is heavily biased towards UNICODE. ... Allocating memory, perhaps by using new, is _very_ time consuming. ... >>> Regards ...
    (microsoft.public.pocketpc.developer)
  • Re: Password Complexity Requirements in Windows 2008 Environment
    ... That's the mimimum but better use at least 8 characters as a minimum. ... Best regards ... This posting is provided "AS IS" with no warranties, ... The Password Complexity Policy is enabled in Default Domain Policy ...
    (microsoft.public.windows.server.active_directory)