Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to share SQL in a multi-query SQL without creating objects?
Maybee this will be of help:
SQL> define string2=",(select dummy d from dual) d"
SQL> select dummy
2 from dual
3 &string2
4 where d.d = dummy;
old 3: &string2
new 3: ,(select dummy d from dual) d
D
-
X Received on Wed Jun 13 2001 - 06:05:31 CDT