Re: Selecting "special" characters from a table

> A fairly simple problem. I have a table with a varchar field ("Name"),
> into which I wish to put the name "O'Leary". How do I escape the '
 character
> so sqlplus doesn't interpret it as the end of the column ?

Just use two ' characters to indicate a ' character, e.g., insert into table values ('O''Leary');

> Likewise, how do I do a select * from table where name = "O'Leary" ?

There is nothing special you need to do for this. Received on Sat Feb 25 1995 - 01:20:34 CET