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
Messages: 1
Registered: November 2007
Junior Member

I want to insert text with apostrophe that is like –
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:

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
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: 63910
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?

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: Mon Oct 24 03:57:42 CDT 2016

Total time taken to generate the page: 0.12123 seconds