-
I want to concantenate a string that includes an & but
I don't want SQLPLUS to prompt me for a variable.
ie; select 'This is a test &' || name from table
-
SET DEFINE OFF;
...will turn that off for you, then
SET DEFINE ON;
...to turn it back on after the insert (if you actually want it on :) )
- Chris
-
-
That is not a problem at all, just go ahead and include "&" within single quotes.
Take care
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|