Oracle SQL Plus pocket reference

Viac o knihe

SQL*Plus is an essential tool for Oracle users, from large data warehouses to single-user systems. Despite its widespread use, many developers and DBAs are unaware of its full potential. This pocket reference offers quick access to SQL*Plus information, summarizing the syntax, including updates for Oracle9i. It distills crucial insights from Gennick's comprehensive guide into an accessible format, serving as a handy companion. The book covers interacting with SQL*Plus, data selection, report formatting, and SQL query tuning, along with quick references to commands and format elements. The updated 2nd edition introduces new features for Oracle9i, such as the COALESCE function, searched CASE expressions, new table join syntax, partition operations, and the MERGE statement, alongside syntax changes for commands like ACCEPT, DESCRIBE, HELP, and SET. Additionally, it includes sections on basic SQL—INSERT, DELETE, UPDATE, SELECT, and transaction management—addressing user requests. The pocket-sized format is ideal for those who use SQL*Plus across various platforms, allowing for easy portability between different work environments.