Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to share SQL in a multi-query SQL without creating objects?

Re: How to share SQL in a multi-query SQL without creating objects?

From: rob <rob_at_dsdelft.nl>
Date: Wed, 13 Jun 2001 13:05:31 +0200
Message-ID: <9g7hdq$64g$1@news.tudelft.nl>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US