How to insert any data in table which contain single quote ('). Like "Father's Name" By Using SQL.

Questions by globalanil18   answers by globalanil18

Showing Answers 1 - 9 of 9 Answers


  • Mar 14th, 2007

you can insert like below insert statment

insert into emp(ename) values('karthy's');

it will inserted or

insert into emp(ename) values('karthy'''s');

you can try with this also

  Was this answer useful?  Yes


  • Mar 14th, 2007

if the above not working
try with this

insert into emp(ename) values('karthy`s');

` ---> use the key adjacent to 1, which is with tilda~ symbol

  Was this answer useful?  Yes

sankar kanna

  • Mar 21st, 2007

insert into employee values('Karthy''s',30000) you can insert by using statement only

  Was this answer useful?  Yes


  • Apr 4th, 2007

insert into employee values('a2','sy'''v','iijr',700,'fh78')(use Two single qoutes)

  Was this answer useful?  Yes

hi all,

we can insert single quote into a table in the following way.

to insert: sandeep's name
table name: temp


insert into temp (name)

values('sandeep''s name');

to fetch the records that have single quotes as values in any table the following code will be used.

select * from temp

where name like '%''%'


sandeep's name


  Was this answer useful?  Yes

When the apostrophe/single quote is at the start of the string, you need to enter 3 single quotes for Oracle to display a quote symbol.

SQL> SELECT '''Hi There'  Message FROM dual;

'Hi There

In the middle of the string, you need to enter 2 single quotes

SQL>  SELECT 'He''s always the first to arrive' Message FROM dual;

He's always the first to arrive

Single quote is at the end of a string, you need to enter 3 single quotes
SQL> SELECT 'Smiths''' FROM dual;

If you were to concatenate an apostrophe/single quote in a string, you need to enter 4 single quotes
SQL> SELECT 'There' || '''' || 's Henry' Message FROM dual;

There's Henry 

  Was this answer useful?  Yes

If we need to insert D'SOUSA.

Query will be


-- Here single quate two times after D
I have tested the query.. It is working file

  Was this answer useful?  Yes


  • Jul 13th, 2011

Here all have given the answer which is for hard coded value for some predefined word.
He is asking and I am too looking for the this Question "ANY DATA".If user don't know whether the coming string is having Quotes or not?
I had tried with replace but it is not working

  1. INSERT IN abc(stringname) VALUES (REPLACE(anyValue," ' ", " '' "));


its not working .
Any Good solution?

  Was this answer useful?  Yes


  • Jul 23rd, 2011

try this its working insert into tablename (vname)values(chr(39)||'name'||chr(39))

output:- 'name'

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions