| Inserting text with apostrophes [message #35863] |
Fri, 19 October 2001 11:34  |
Trevor Pearson
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
Does anybody know how to build an insert statement to insert any text with apostrophes without knowing where the apostrophes are? or even if there are apostrophes?
some of my data gets kicked out as 'string not properly terminated' errors bec. of apostrophes.
thanks,
trevor
----------------------------------------------------------------------
|
|
|
|
| Re: Inserting text with apostrophes [message #35867 is a reply to message #35863] |
Sat, 20 October 2001 03:45  |
Milan Kumar Barui
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
Hi Trevor,
Suppose you want to insert " Trevor's " in table which has one column named a.
I think you are are inserting like :
Insert into table_name(a) values('Trevor's');
Instead of that if you give two single quote in the place of one single quote, then it works. ex.
Insert into table_name(a) values('Trevor''s');
Try this.
Thanks
Milan
Oracle DBA
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
