Oracle DBA SQL Quick Reference
Published on 10. July 2003
Book
Paperback/Softback
560 pages
978-0-13-140303-1 (ISBN)
Description
Most Oracle DBAs spend the majority of their time each day doing pretty much the same things they do every other day. This is because they don't have any problem remembering the syntax and commands they want to use. The rest of their time, however, they're doing something they may only do once every few months - and that's the time they need help. This will be a simple, small, single volume quick reference that will remind them of the syntax and options of a command they rarely use or give them a quick reminder of the available views and tables that make up a DBAs life - the DBA_and v$ tables.
More details
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Width: 228 mm
Thickness: 23 mm
Weight
667 gr
ISBN-13
978-0-13-140303-1 (9780131403031)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
CHARLIE RUSSEL has extensive system administration and Oracle DBA experience in both Windows and UNIX environments. His books include Microsoft Windows 2000 Server Administrator's Companion, second edition, Microsoft Windows Server 2003 Administrator's Companion (MS Press), UNIX and Linux Answers! Certified Tech Support, and NT and UNIX Intranet Secrets (IDG).
ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Russel and Cordingley are also co-authors of Oracle DBA Scripting Quick Reference (Prentice Hall PTR).
ROBERT CORDINGLEY is an Oracle DBA in Austin, Texas. Russel and Cordingley are also co-authors of Oracle DBA Scripting Quick Reference (Prentice Hall PTR).
Content
Introduction.
How To Use This Book.
Talk To Us.
Acknowledgments.
1. Programmatic and General Reference.
Operators. Arithmetic Operators. Logical Operators. Comparison Operators. Select Operators. Precedence. Functions. Single Row Functions. Aggregate Functions. Analytical Functions. Object Reference Functions. Format models. Date Format Models. Date Prefixes and Suffixes. Number Format Models. Reserved Words. Privileges. System Privileges. Object Privileges.
2. SQL Command Reference.
Alter. Alter Cluster. Alter Database. Alter Dimension. Alter Function. Alter Index. Alter Indextype. Alter Java. Alter Materialized View. Alter Materialized View Log. Alter Operator. Alter Outline. Alter Package. Alter Procedure. Alter Profile. Alter Resource Cost. Alter Role. Alter Rollback Segment. Alter Sequence. Alter Session. Alter System. Alter Table. Alter Tablespace. Alter Trigger. Alter Type. Alter User. Alter View. Analyze. Associate Statistics. Audit. Call. Comment. Commit. Create. Create Cluster. Create Context. Create Controlfile Create Database. Create Database Link. Create Dimension. Create Directory. Create Function. Create Index. Create Indextype. Create Java. Create Library. Create Materialized View. Create Materialized View Log. Create Operator. Create Outline. Create Package. Create Package Body. Create pfile. Create Procedure. Create Profile. Create Role. Create Rollback Segment. Create Schema. Create Sequence. Create spfile. Create Synonym. Create Table. Create Tablespace. Create Temporary Tablespace. Create Trigger. Create Type. Create Type Body. Create User. Create View. Delete. Disassociate Statistics. Drop. Explain Plan. Grant. Insert. Lock Table. Merge. Noaudit. Rename. Revoke. Rollback. Savepoint. Select. Set Constraint[s]. Set Role. Set Transaction. Truncate. Update. Common. Allocate extent. Constraints. Deallocate Unused. File Specification. Logging. Parallel. Physical Attributes. Storage.
3. Special Views and Tables.
Data Dictionary Views. Dynamic Tables.
How To Use This Book.
Talk To Us.
Acknowledgments.
1. Programmatic and General Reference.
Operators. Arithmetic Operators. Logical Operators. Comparison Operators. Select Operators. Precedence. Functions. Single Row Functions. Aggregate Functions. Analytical Functions. Object Reference Functions. Format models. Date Format Models. Date Prefixes and Suffixes. Number Format Models. Reserved Words. Privileges. System Privileges. Object Privileges.
2. SQL Command Reference.
Alter. Alter Cluster. Alter Database. Alter Dimension. Alter Function. Alter Index. Alter Indextype. Alter Java. Alter Materialized View. Alter Materialized View Log. Alter Operator. Alter Outline. Alter Package. Alter Procedure. Alter Profile. Alter Resource Cost. Alter Role. Alter Rollback Segment. Alter Sequence. Alter Session. Alter System. Alter Table. Alter Tablespace. Alter Trigger. Alter Type. Alter User. Alter View. Analyze. Associate Statistics. Audit. Call. Comment. Commit. Create. Create Cluster. Create Context. Create Controlfile Create Database. Create Database Link. Create Dimension. Create Directory. Create Function. Create Index. Create Indextype. Create Java. Create Library. Create Materialized View. Create Materialized View Log. Create Operator. Create Outline. Create Package. Create Package Body. Create pfile. Create Procedure. Create Profile. Create Role. Create Rollback Segment. Create Schema. Create Sequence. Create spfile. Create Synonym. Create Table. Create Tablespace. Create Temporary Tablespace. Create Trigger. Create Type. Create Type Body. Create User. Create View. Delete. Disassociate Statistics. Drop. Explain Plan. Grant. Insert. Lock Table. Merge. Noaudit. Rename. Revoke. Rollback. Savepoint. Select. Set Constraint[s]. Set Role. Set Transaction. Truncate. Update. Common. Allocate extent. Constraints. Deallocate Unused. File Specification. Logging. Parallel. Physical Attributes. Storage.
3. Special Views and Tables.
Data Dictionary Views. Dynamic Tables.