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