Home » SQL & PL/SQL » SQL & PL/SQL » Inserting text with apostrophes
Inserting text with apostrophes [message #35863] Fri, 19 October 2001 11:34 Go to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: why can't we use Commit in triggers
Next Topic: Converting a columns to uppercase..
Goto Forum:
  


Current Time: Thu Apr 02 05:28:12 CDT 2020