Oracle DBA SQL Quick Reference
暫譯: Oracle DBA SQL 快速參考指南

Charlie Russel, Robert Cordingley

  • 出版商: Prentice Hall
  • 出版日期: 2003-06-26
  • 售價: $1,360
  • 貴賓價: 9.5$1,292
  • 語言: 英文
  • 頁數: 560
  • 裝訂: Paperback
  • ISBN: 0131403036
  • ISBN-13: 9780131403031
  • 相關分類: OracleSQL
  • 已過版

商品描述

Summary

  • 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

Table of Contents

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 Constraints. 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.

商品描述(中文翻譯)

摘要

- 每位資料庫管理員(DBA)都需要的 Oracle SQL—快速且簡單!
- 涵蓋 DBA 負責的所有核心日常任務
- 快速訪問 SQL 命令、運算符、函數、數據字典視圖等
- 包含數十個易於理解的語法圖

每位 Oracle DBA 的快速實用 Oracle SQL 參考資料!

如果你是一名在職的 Oracle DBA,這就是你一直在尋找的 Oracle SQL 參考資料—簡單、直接且極其易用!沒有比這更快的方法來發現你所需的確切語法……刷新你對最近未使用的選項的記憶……找到你知道存在的視圖名稱……開始使用你尚未嘗試過的新 Oracle 9i 功能。將它放在你的桌子旁,靠近你的伺服器……無論你需要快速、可靠的答案的地方,隨時都能使用!

- 涵蓋 Oracle SQL 直至 Oracle9i Release 2
- 清晰、組織良好的運算符、函數、格式模型、權限和保留字表格
- 完整的命令參考:每個 Oracle SQL 命令的語法和選項
- 標準的「鐵路」語法圖使得編寫正確的語法變得容易
- 方便的數據字典視圖和動態性能表的列表

目錄

- 介紹
- 如何使用本書
- 聯繫我們
- 感謝詞
- 1. 程式性和一般參考

運算符。算術運算符。邏輯運算符。比較運算符。選擇運算符。優先順序。函數。單行函數。聚合函數。分析函數。物件參考函數。格式模型。日期格式模型。日期前綴和後綴。數字格式模型。保留字。權限。系統權限。物件權限。

- 2. SQL 命令參考

修改。修改叢集。修改資料庫。修改維度。修改函數。修改索引。修改索引類型。修改 Java。修改物化視圖。修改物化視圖日誌。修改運算符。修改大綱。修改套件。修改程序。修改配置檔。修改資源成本。修改角色。修改回滾段。修改序列。修改會話。修改系統。修改表。修改表空間。修改觸發器。修改類型。修改使用者。修改視圖。分析。關聯統計。審計。呼叫。註解。提交。創建。創建叢集。創建上下文。創建控制檔。創建資料庫。創建資料庫連結。創建維度。創建目錄。創建函數。創建索引。創建索引類型。創建 Java。創建庫。創建物化視圖。創建物化視圖日誌。創建運算符。創建大綱。創建套件。創建套件主體。創建 pfile。創建程序。創建配置檔。創建角色。創建回滾段。創建架構。創建序列。創建 spfile。創建同義詞。創建表。創建表空間。創建臨時表空間。創建觸發器。創建類型。創建類型主體。創建使用者。創建視圖。刪除。解除關聯統計。刪除。解釋計劃。授權。插入。鎖定表。合併。無審計。重新命名。撤銷。回滾。保存點。選擇。設置約束。設置角色。設置交易。截斷。更新。常見。分配擴展。約束。釋放未使用。文件規範。日誌。並行。物理屬性。存儲。

- 3. 特殊視圖和表

數據字典視圖。動態表。