Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting '&' character

109137Nov 26 2001
morning folks

does anyone know how to insert the '&' character via SQL plus
without there being a prompt for variables?

i created this test table...
create table x(a varchar2(40));

this causes a prompt to appear in sqlplus when i issue...
insert into x values ('fish & chips');

this dosn't but its a bit messy...
insert into x values ('fish '||'''&'''|| ' chips');

any easy way of switching this prompt off?

kind regards

Satnam

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2001
Added on Nov 26 2001
4 comments
239 views