The Oracle SQL every DBA needs--fast and easy!
Covers all the core day-to-day tasks DBAs are responsible for
Quick access to SQL commands, operators, functions, data dictionary views, and more
Includes dozens of easy-to-understand syntax diagrams
The fast, practical Oracle SQL reference for every Oracle DBA!
If you're a working Oracle DBA, here's the Oracle SQL reference you've been searching for--simple, straightforward, and incredibly easy to use! There's no faster way to discover the exact syntax you need...refresh your memory about that option you haven't used lately...find the name of that view you know exists...start using that new Oracle 9i feature you haven't tried yet.
Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute!
Covers Oracle SQL through Oracle9i Release 2
Clear, well-organized tables of operators, functions, format models, privileges, and reserved words
Complete command reference: syntax and options for every Oracle SQL command
Standard 'railroad' syntax diagrams make it easy to write correct syntax
Handy listings of data dictionary views and dynamic performance tables
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).
Table of Contents
How To Use This Book.
Talk To Us.
1. Programmatic and General Reference.
Single Row Functions.
Object Reference Functions.
Date Format Models.
Date Prefixes and Suffixes.
Number Format Models.
2. SQL Command Reference.
Alter Materialized View.
Alter Materialized View Log.
Alter Resource Cost.
Alter Rollback Segment.
Create Database Link.
Create Materialized View.
Create Materialized View Log.
Create Package Body.
Create Rollback Segment.
Create Temporary Tablespace.
Create Type Body.
3. Special Views and Tables.
Data Dictionary Views.