Description
Book SynopsisThis portable, quick-reference guide is a must-have for developers and DBAs looking to maximize use of SQL*Plus. The new third edition of the' Oracle SQL*Plus Pocket Reference' updates the SQL*Plus syntax and format options for Oracle Database 10g, Oracle's latest database release.
Table of ContentsIntroduction Command-Line SQL*Plus Starting SQL*Plus Entering Commands Strings in SQL*Plus Commands Specifying Filenames Naming Variables Browser-Based SQL*Plus Starting and Stopping iSQL*Plus Connecting to iSQL*Plus Connecting to a Database Connecting as SYSDBA Creating SYSDBA Users; Entering and Executing Commands Getting Output as Plain Text; Executing Scripts Disconnecting from iSQL*Plus Selecting Data The SELECT Statement Nulls CASE Expressions; Table Joins (Oracle8i and Earlier) Table Joins (Oracle9i and Higher) Partition Outer Joins Summary Queries Unions; Partition Operations Flashback Queries Modeling Data; MODEL Clause Syntax MODEL Clause Functions MODEL Clause Example Inserting Data Inserting One Row Inserting the Results of a Query Multitable Inserts (Oracle9i and Higher); Updating Data Simple Updates Noncorrelated Subqueries in the SET Clause Correlated Subqueries in the SET Clause Deleting Data Simple Deletes Deleting All Rows (TRUNCATE) Deleting Duplicate Rows Merging Data (Oracle9i and Higher) Transaction Management SET TRANSACTION SAVEPOINT COMMIT ROLLBACK; Formatting Text Reports Column Headings Column Formats; Page Width and Length Page Headers and Footers Page Breaks; Report Breaks Formatting HTML Reports The Concatenation Approach Generating Full Pages Tuning SQL Creating the Plan Table Explaining a Query Using DBMS_XPLAN Querying the Plan Table Using Optimizer Hints SQL*Plus Format Elements Formatting Numbers Formatting Character Strings; Formatting Dates SQL*Plus Command Reference Index
