Advanced SQL Techniques
This chapter completes the learning process started in Chapter 2, and covers more advanced techniques using the SQL language. The final part of this chapter will apply these new techniques and show how to create some popular types of reports using SQL*Plus. This chapter also covers a variety of topics related to SQL queries including functions, advanced queries (joins and subqueries), complex views, and read consistency (Oracle9i locking mechanisms).
Functions
SQL functions perform a variety of tasks such as date compares; date formatting; a host of character functions such as string length, substring functions, uppercase/lowercase; as well as several numerical functions such as round, truncate, and arithmetic operations. ...
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.
