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!

SET DEFINE OFF

blueoraFeb 20 2010 — edited Mar 1 2012
I had an insert script with data strings having '&' character. While executing it on sqlplus it prompted for a value at each occurrence of '&' .

Simple solution was to put a "SET DEFINE OFF" at the beginning of the script. It suppressed the prompt for value.

However, it left me with a question. What if my insert script require both things...
1. Insert data strings having '&' character.
2. Prompt for a value at few places.

How would I achieve that?

Thanks for your inputs.

--Rob
This post has been answered by 728534 on Feb 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2012
Added on Feb 20 2010
5 comments
136,270 views