[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
EA[CH] parameter (SET RECSEP) ECHO setting 2nd echoing commands 2nd 3rd ed, problems with ED[IT] command 2nd work file name EDITF[ILE] setting editing [See line editing] editor, choosing elapsed time capturing EMPLOYEE entity (sample database) 2nd EMPLOYEE table (sample database) 2nd entity descriptions (sample database) Entity Relationship Diagram (ERD) (sample database) ENTRY parameter (SET FLAGGER) environment customizing dependencies for editor, choosing prompt, customizing 2nd startup scrips variables, OS environment environment variables $ORACLE_HOME NLS_LANG products affected operating system script search path service name LOCAL environment variable SQL*Plus, significant Windows GUI version ERD (Entity Relationship Diagram) for sample database ERR[ORS] parameter (SHOW) 2nd error codes, capturing error handling limitations in SQL*Plus ESC[APE] setting 2nd escaping the substitution variable prefix Excel-specific hack, extracting data EXEC[UTE] command 2nd 3rd executing DDL and DML commands single PL/SQL commands execution plans creating plan table displaying plan execution statistics. displaying explaining queries improving performance interpreting results judging results operations performance views, accessing query output, suppressing understanding execution statistics EXIT clause (WHENEVER) 2nd EXIT command 2nd 3rd 4th exiting exiting SQL*Plus 2nd EXP[LAIN] parameter (SET AUTOTRACE) EXPLAIN PLAN 2nd 3rd creating plan table 2nd displaying execution plan interpreting results 2nd syntax for external text editors editing buffers with |
لطفا منتظر باشید ...
• 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.
