The With Clause (Oracle)

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]

Oracle LazyDBA home page