There is a varchar2 column ,How can I insert data which contains ' in it ,eg-Ora'cle ??The value to be inserted may vary with every insertion and we can't specifically tell as to whats the position of single quotes ..

Interview Candidate
Sep 17th, 2006
4
1750

Showing Answers 1 - 4 of 4 Answers

Musharraf Dabre

Sep 18th, 2006

You need to use UNISTR() function.
for eg: oracl'e
enter the sql:
insert into tablename values('oracl'||unistr('300')||'e');
ouput:
1 row created.
then say:
select * from tablename;

Anu

Sep 18th, 2006

Hi,
   You can do it in this way
    insert into test values('ora''cle');
   use two single quotes side by side..(its not a double quote)
   hope this will work
Regards,
Anu

senthilkumar

Oct 12th, 2006

-MS SSQL Inserting integer values in to varchar columINSERT INTO (col1) VALUES(CONVERT(VARCHAR,10))

senkumaar
Profile

Oct 12th, 2006

In MS-SQL server we can use likeINSERT INTO () VALUES CONVERT(VARCHAR,))ExampleINSERT INTO SEN_TEST(NAMEE) VALUES(CONVERT(VARCHAR,10))