[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
A[PPEND] command 2nd 3rd ABORT parameter (SHUTDOWN) aborting database instance ACC[EPT] command 2nd format specifications with 2nd 3rd validating user input access method hints administration automating routine DBA tasks starting/stopping databases 2nd advanced reports current date into headers formatting 2nd from Oracle formatting object columns headers and footers summary reports timestamping spool files totals and subtotals COMP[UTE] and BRE[AK] commands printing grand totals 2nd 3rd 4th printing subtotals unions final report typical example UNION query advanced scripting bind variables blank lines, generating conditional execution multilevel file structure, using OS scripting language for PL/SQL for simulating with REFCURSOR datatype simulating with WHERE clause SQL writing SQL error handling error codes, capturing failure codes, passing back error handling limitations WHENEVER command execution failure ROLLBACK option (WHENEVER) looping recursive execution within PL/SQL recursive execution timing [See timers] UNIX, returning values to user input, parsing with SQL user input, validating and parsing ACC[EPT] command ACCEPTing date values ACCEPTing numeric values user input, validating with SQL advancing to new page (reports) aggregate functions ALI[AS] clause ATTRIBUTE command COLUMN command ALL parameter ARCHIVE LOG command SHOW command ALL views ALL_ALL_TABLES view ALL_COL_PRIVS view ALL_CONS_COLUMNS view 2nd ALL_IND_COLUMNS view ALL_INDEXES view 2nd ALL_SOURCE view 2nd ALL_SYNONYMS view ALL_TAB_COLUMNS view 2nd 3rd ALL_TAB_PRIVS view ALL_TABLES view 2nd ALL_TRIGGER_COLS view ALL_TRIGGERS view ALL_USERS view correspondence with user and dba views ALL_ROWS hint ALTER SESSION statement, formatting dates ALTER USER command, changing password with AND-EQUAL operation (EXPLAIN PLAN) ANSI/ISO SQL92 syntax conformance checks APP[END] parameter COPY command SAVE command STORE command APPI[NFO] setting application security archive information, viewing ARCHIVE LOG command ARRAY[SIZE] command AS keyword (CONNECT command) asterisk (*) identifying errors in SQL statements line editing keyword 2nd 3rd ATTRIBUTE command 2nd AUFI (Advanced User Friendly Interface) AUTO[COMMIT] setting automating routine DBA tasks AUTOP[RINT] setting AUTORECOVERY setting AUTOT[RACE] setting 2nd AVG parameter (COMPUTE command) |
لطفا منتظر باشید ...
• Table of Contents • Index • Reviews • Reader Reviews • Errata • Academic Oracle SQL*Plus: The Definitive Guide, 2nd Edition By
Jonathan Gennick Publisher : O''Reilly Pub Date : November 2004 ISBN : 0-596-00746-9 Pages : 582
Updated for Oracle 10g, this bestselling book is the only
in-depth guide to SQL*Plus. It clearly describes how to
perform, step-by-step, all of the tasks that Oracle
developers and DBAs want to perform with SQL*Plus--and maybe
some you didn''t realize you could perform. If you want to
leverage of the full power and flexibility of this popular
Oracle tool, this book is an indispensable resource.
