OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CHAR ' (ORACLE 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CHAR ' [message #646900]

Thu, 14 January 2016 03:59

NNAAEE
Messages: 4
Registered: January 2016

Junior Member

How insert word Ceed's in a oracle table?

Report message to a moderator

Re: CHAR ' [message #646901 is a reply to message #646900]

Thu, 14 January 2016 04:10

John Watson
Messages: 9002
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I think you are asking how to insert a string containing an apostrophe? Look up the use of quote delimiters for string literals here,
http://docs.oracle.com/database/121/SQLRF/sql_elements003.htm#SQLRF00217

Report message to a moderator

Re: CHAR ' [message #646902 is a reply to message #646901]

Thu, 14 January 2016 04:47

NNAAEE
Messages: 4
Registered: January 2016

Junior Member

Thanks!

Report message to a moderator

Re: CHAR ' [message #646903 is a reply to message #646902]

Thu, 14 January 2016 05:39

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

user escape character or just insert using '''

insert into test values ('Ceed''s');

Report message to a moderator

Re: CHAR ' [message #646904 is a reply to message #646903]

Thu, 14 January 2016 05:43

NNAAEE
Messages: 4
Registered: January 2016

Junior Member

Thanks!

Report message to a moderator

Re: CHAR ' [message #646905 is a reply to message #646903]

Thu, 14 January 2016 05:57

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no escape character in SQL.
You can either double the quotes or use the quote delimiter syntax es explained in John's link.
Here's example:

SQL> select 'Ceed''s' m1, q'(Ceed's)' m2, q'/Ceed's/' m3, q';Ceed's;' m4 from dual;
M1     M2     M3     M4
------ ------ ------ ------
Ceed's Ceed's Ceed's Ceed's

Report message to a moderator

Re: CHAR ' [message #646911 is a reply to message #646905]

Thu, 14 January 2016 07:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(ORACLE 6i)
I suspect above is not correct

post full output of SQL below

SELECT * FROM V$VERSION;

Report message to a moderator

Re: CHAR ' [message #646920 is a reply to message #646911]

Thu, 14 January 2016 13:42

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That would be Forms 6i, I presume.

Report message to a moderator

Re: CHAR ' [message #646921 is a reply to message #646920]

Thu, 14 January 2016 14:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

But that does not answer the question about which Oracle version

Report message to a moderator

Re: CHAR ' [message #647017 is a reply to message #646921]

Mon, 18 January 2016 06:25

NNAAEE
Messages: 4
Registered: January 2016

Junior Member

Oracle8i Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

Report message to a moderator

Re: CHAR ' [message #647018 is a reply to message #647017]

Mon, 18 January 2016 07:42

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you are in 8i then you can't use the quote delimiter syntax, your only solution is to double the quotes.

Do you also use Windows NT4? Wink

Report message to a moderator

Re: CHAR ' [message #647026 is a reply to message #647018]

Mon, 18 January 2016 08:38

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

Michel Cadot wrote on Mon, 18 January 2016 07:42

If you are in 8i then you can't use the quote delimiter syntax, your only solution is to double the quotes.

Do you also use Windows NT4?

The OP must be working here. Smile

Report message to a moderator

Previous Topic:	SQL Query
Next Topic:	VARCHAR2 Convert to H:MI:SS tt (merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 26 23:46:56 CDT 2026