Master: How to insert a string with "'" in the table? Author: HNALBERT (again war) level: credit value: 91 community: Oracle foundation and management problem points: 50 replies: 7 Posted: 2004-04-15 08: 07: 33z
If the string is "Brother's Family", how can I insert into the database?
INSERT INTO TABLE1 VALUES ('Brother's Family') is definitely not.
Reply to: Yfjyz (DD) () Reputation: 99 2004-04-15 08: 11: 54Z score: 10
INSERT INTO TABLE1 VALUES ('Brother''s Family ')
TOP
Reply to: Marvinhong (Border Camel) () Reputation: 99 2004-04-15 08: 12: 23Z Score: 10
INSERT INTO TABLE1 VALUES ('Brother' || CHR (39) || 'S Family')
TOP
Reply to: DLmaomao (Cat) () Reputation: 100 2004-04-15 08: 42: 54Z score: 4
Still upstairs, good methods:
INSERT INTO TABLE1 VALUES ('Brother' || CHR (39) || 'S Family');
TOP
Reply to: Soniczck (City Crop) () Reputation: 100 2004-04-15 11: 25: 44Z Score: 3
Both methods are
TOP
Reply to: XBM2002 () () Reputation: 97 2004-04-15 15: 34: 41Z score: 3
Yes, two methods
TOP
Reply to: HNALBERT () Reputation: 91 2004-04-15 18: 20: 36z Score: 0
In addition, ask a related problem, like "'" this escape character, how much is it in Oracle?
Where can I find it?
Thank you!
TOP
Reply to: Skystar99047 (Star) () Reputation: 100 2004-04-15 18: 32: 46Z Score: 20
I can't write directly, I will use CHR ().
TOP
