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

Home -> Community -> Usenet -> c.d.o.misc -> Re: "Embed" command files inside queries?

Re: "Embed" command files inside queries?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Sep 2005 07:39:38 -0700
Message-ID: <1127313578.732569.230900@g44g2000cwa.googlegroups.com>


Eric, Based on our systems any SQL statement that fits on a single screen is short!

Oracle does have a feature that amounts to replacing a SQL statement with a label in another part of the SQL statement. See the WITH clause in the SQL manual. The WITH clause is especially useful when you need to use the exact same subquery in an SQL statement two or more times.

HTH -- Mark D Powell -- Received on Wed Sep 21 2005 - 09:39:38 CDT

Original text of this message

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