DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 'siva's' - inserting this value in select statement

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    'siva's' - inserting this value in select statement

    see i have a varchar2 value siva

    in the insert statement i have tp put it as - 'siva's'' - it is not allowing me to do so. i donot want to insert any extra caharacters other than this.

    how can we do with this .

    Thanks in advance
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Just add an additional '

    eg.

    Code:
    INSERT INTO testtable (col1)
    VALUES ('testing an insert with a '' in it');
    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width