With query was introdused with oracle 9i
With queryname allows to assign a name to the sub query block, this sub
qyery block can be used further with the name assigned to it

Arshad

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x93374382.[Email address protected]
Sent: Friday, October 06, 2006 3:37 PM
To: LazyDBA Discussion
Subject: The With Clause (Oracle)

To All,
Well, well, well! It's good to be back! Can you hear me now? What's in
your wallet? Hehe. It's Friday! It's quiz time! Can you win the Coke?
Hehe.

1. What is this "with" clause in Oracle?

2. What version was it first used in Oracle?

3. What was the first database to use the "with"?

4. Is it a command or function?

5. Is it straight SQL or PL-SQL?

4. What are the advantages of using it?

5. What are the disadvantages of using it?


My young, junior DBAs loved this question! I sure do miss them! Let me end
now before tears startup!


Please take a few minutes to provide feedback on the quality of service you
received. The Department of Education values your feedback as a customer.
Commissioner John L. Winn is committed to continuously assessing and
improving the level and quality of services provided to you by Department
staff. Simply use the link below. Thank you in advance for completing the
survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page