The second edition of this popular pocket guide allows you to quickly find the necessary background information that helps you make better use of SQL * Plus. Here you will find brief descriptions of all formats and syntax of all elements of SQL * Plus, including the new, introduced in Oracle9i Release 2, such as a function COALESCE, search expressions CASE, join tables, multiple-paste and so on. The book summarizes the issues with SQL * Plus, formatted reports using SQL * Plus, SQL-queries settings. In addition, the new edition was included background information on the instructions of SQL, which are most often used in SQL * Plus, including SELECT, INSERT, UPDATE, DELETE, MERGE, and on the instructions of transaction management, including the COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION.
No feedback yet