[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
TAB clause REPHEADER, REPFOOTER commands TTITLE command TAB setting 2nd TABLE ACCESS operation (EXPLAIN PLAN) table constraints CHECK constraint foreign key constraints primary key and unique constraints type of table-level grants tables ALL_TAB_COLUMNS ALL_TABLES view column definitions for column definitions, listing with DESCRIBE 2nd constraints on CHECK constraints foreign key constraints primary key and unique constraints types of definitions of, viewing DUAL (special Oracle table) highwater mark, direct path into indexes, listing joins full outer 2nd inner old syntax outer listing owners combining tables external tables object tables other users recycle bin plan table interpreting sample database EMPLOYEE 2nd PROJECT 2nd 3rd PROJECT HOURS 2nd security (privileges), ALL_TAB_PRIVS view synonyms (alternate name for) TERM[OUT] setting 2nd 3rd prompting for values and terminal output TERMINATED BY clause (SQL*Loader) terminating SQL statements termination character for substitution variables text editors 2nd text files TI[ME] setting time in command prompt timers displaying value without stopping elapsed time, capturing nesting number of active timers resolution of 2nd SET TIMING command starting and stopping stopping all TIMI[NG] command 2nd using timestamping spool files TIMI[NG] command 2nd TIMI[NG] parameter (CLEAR) 2nd TIMI[NG] setting 2nd TO_CHAR function converting numbers to strings formatting dates 2nd TO_DATE function 2nd toggling TRACE[ONLY] parameter (SET AUTOTRACE) 2nd transactional database shutdown TRANSACTIONAL parameter (SHUTDOWN) transactions data integrity 2nd pervasiveness of ROLLBACK statement 2nd types of triggers ALL_TRIGGER_COLS view ALL_TRIGGERS view TRIM[OUT] setting 2nd TRIMS[POOL] setting 2nd troubleshooting error handling limitation in SQL*Plus errors in SQL statements 2nd 3rd 4th querying product user profile TRU[NCATED] parameter COLUMN command 2nd SET SERVEROUTPUT command TRUNCATE TABLE statement TTI[TLE] command 2nd 3rd number format specifications REPHEADER command vs. TTI[TLE] parameter (SHOW) tuning information |
لطفا منتظر باشید ...
• 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.
