Insert &s
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Insert &s

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Hi!
    Whenever I am trying to fire the following insert it is prompting for enter value of co.

    insert into trial (name) values ('abc & co');

    what is escape sequence for &?


    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Jul 2000
    Posts
    243
    Hi

    what version are you on ? i just tested it on 8.1.7 and no problems and no need for escape sequence for &!

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    I am using 8.1.6.

    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    I tested : got the same problem as yours ... the workaround is :

    insert into trial(name)
    values ('abc ' || chr(38) || ' co');

  5. #5
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    YEah it worked Thanx
    There Nothing You cannot Do, The problem is HOW.

  6. #6
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    set Options-ESCAPE= \ in SQLPLUS

    Hi, 16th May 2001 14:38 hrs *******


    1)Type as escape on

    2)Go to menu in SQL Plus OPTIONS==>ENVIRONMENT==>ESCAPE==>VALUE(set it as / )

    3)Come to SQL PLUS screen and now insert a value as

    SQL> insert into values('abc \& co');

    Well finished.

    Cheers

    Padmam

    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  7. #7
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: set Options-ESCAPE= \ in SQLPLUS

    Hi, 16th May 2001 15:09 hrs *******

    you can also mark it as

    SET ESCAPE ON
    SET ESCAPE "\"

    followed by insert in to the table.

    in SQL PLUS

    cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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