Oracle SQL*Plus pocket reference
The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the s...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2005.
|
| Edición: | 3rd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628422506719 |
Tabla de Contenidos:
- Contents; Oracle SQL*Plus Pocket Reference; Introduction; Acknowledgments; Conventions; Command-Line SQL*Plus; Starting SQL*Plus; Syntax for the sqlplus command; Entering Commands; Entering SQL*Plus commands; Entering SQL statements; Entering PL/SQL blocks; 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 DataThe SELECT Statement; Selecting columns from a table; Ordering query results; Restricting query results; Using column aliases; Factoring out subqueries; Nulls; Using the NVL function; Using the COALESCE function; CASE Expressions; Simple CASE expressions; Searched CASE expressions; Table Joins (Oracle8i and Earlier); Inner and outer joins; Table Joins (Oracle9i and Higher); Sample tables; Inner joins; Join order; Left and right outer joins; Full outer joins; Specifying join conditions; Partition Outer Joins; Summary Queries; Using aggregate functions; Using GROUP BY
- Restricting summarized resultsUsing ALL and DISTINCT; 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 intheSETClause; Correlated Subqueries in the SET Clause; Deleting Data; Simple Deletes; Deleting All Rows (TRUNCATE); Deleting Duplicate Rows; Merging Data (Oracle9i andHigher); Transaction Management; SET TRANSACTION; SAVEPOINT; COMMIT; ROLLBACK
- Formatting Text ReportsColumn Headings; Column Formats; Page Width and Length; Page Headers and Footers; Defining a title; Getting the date into a title; Page Breaks; Report Breaks; The BREAK command; The COMPUTE command; Formatting HTML Reports; The Concatenation Approach; Generating Full Pages; Controlling page format; Controlling column format; Tuning SQL; Creating the Plan Table; Explaining a Query; EXPLAIN PLAN syntax; EXPLAIN PLAN example; Using DBMS_XPLAN; Querying the Plan Table; Using Optimizer Hints; Hint query blocks; Optimizer goal hints; Access method hints; Join order hints
- Join operation hintsQuery transformation hints; Miscellaneous hints; SQL*Plus Format Elements; Formatting Numbers; Formatting Character Strings; Formatting Dates; SQL*Plus Command Reference; Comment Delimiters (/*...*/); Double Hyphen (
- ); At Sign (@); Double At Sign (@@); Forward Slash (/); ACCEPT; APPEND; ARCHIVE LOG; ATTRIBUTE; BREAK; BTITLE; CHANGE; CLEAR; COLUMN; COMPUTE; CONNECT; COPY; DEFINE; DEL; DESCRIBE; DISCONNECT; EDIT; EXECUTE; EXIT; GET; HELP; HOST; INPUT; LIST; PASSWORD; PAUSE; PRINT; PROMPT; QUIT; RECOVER; REMARK; REPFOOTER; REPHEADER; RUN; SAVE; SET; SHOW; SHUTDOWN; SPOOL
- START
