Home » SQL & PL/SQL » SQL & PL/SQL » how to insert ?
how to insert ? [message #277977] Thu, 01 November 2007 06:19 Go to next message
svijayakumaris
Messages: 1
Registered: November 2007
Junior Member
Hi

I want to insert text with apostrophe that is like –
one’s
two’s etc. in a database table
I tried like this
insert into temp values('one\'s');

but it is giving error – missing comma

How can I insert the text with apostrophe (‘) in the table?

I want data like this:

DESCRIPTION
Kittu's
Vijaya's
Re: how to insert ? [message #277978 is a reply to message #277977] Thu, 01 November 2007 06:22 Go to previous messageGo to next message
sandeep.kushwaha
Messages: 10
Registered: October 2007
Location: India
Junior Member

Try this
insert into temp values('one''s');
Re: how to insert ? [message #277985 is a reply to message #277977] Thu, 01 November 2007 06:49 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And next time, read OraFAQ Forum Guide and search before posting.
Do you think you're the first one to ask yourself this question during the past 30 years Oracle exist?

Regards
Michel
Previous Topic: Long Sql used for Ref Cursor - Getting Invalid Identifier error
Next Topic: MERGE statement: Possible to use DELETE and INSERT only?
Goto Forum:
  


Current Time: Tue Dec 06 04:10:32 CST 2016

Total time taken to generate the page: 0.08045 seconds