-
Hi,
What does set define '~' does in sql plus environment.
Badrinath
-
It changes the subsitution variable indicator to a '~'.
The default is '&'.
So without the command, if you try this :
select 'a & b' from dual;
you get this :
enter value for b :
but after the command, you get this :
'A&B'
-----
a & b
and now, if you issue
select 'a ~ b' from dual;
you get
enter value for b :
hth
-John
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
|