Arshad,
You did not complete the quiz? Hehe.


2. What version was it first used in Oracle? (which one - 9.0, 9.1,
9.2)

3. What was the first database to use the "with"? (Oracle, SQL Server,
DB2)

4. Is it a command or function?

5. Is it straight SQL or PL-SQL?

7. What are the disadvantages of using it?



-----Original Message-----
From: Arshad Hamid
[mailto:oracledba-ezmlmshield-x96073010.[Email address protected]
Sent: Friday, October 06, 2006 6:29 AM
To: LazyDBA Discussion
Subject: RE: The With Clause (Oracle)

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





---------------------------------------------------------------------
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