Reviewing It

1:What is the purpose of SQL functions?
2:What is the DUAL table useful for?
3:Explain SQL concatenation.
4:The DECODE statement is what?
5:When might you use the HAVING clause?
6:Briefly describe what a JOIN is.
7:What is 'qualification' and why is it important to a self-join?
8:Name the four types of sub-queries.
9:What is an IN-LINE view?

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.