Oracle Database 11g SQL (Paperback)

Jason Price

  • 出版商: McGraw-Hill Education
  • 出版日期: 2007-11-01
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 688
  • 裝訂: Paperback
  • ISBN: 0071498508
  • ISBN-13: 9780071498500
  • 相關分類: OracleSQL資料庫
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Description

Write powerful SQL statements and PL/SQL programs

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

  • Explore SQL Plus and SQL Developer
  • Use SQL SELECT, INSERT, UPDATE, and DELETE statements
  • Write PL/SQL programs
  • Create tables, sequences, indexes, views, and triggers
  • Write advanced queries containing complex analytical functions
  • Create database objects and collections to handle abstract data
  • Use large objects to handle multimedia files containing music and movies
  • Write Java programs to access an Oracle Database using JDBC
  • Tune your SQL statements to make them execute faster
  • Explore the XML capabilities of the Oracle Database
  • Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

商品描述(中文翻譯)

描述

撰寫強大的SQL語句和PL/SQL程式
從Oracle專家Jason Price的指導下,學習通過SQL語句訪問Oracle數據庫並構建PL/SQL程式。由Oracle Press出版,《Oracle Database 11g SQL》解釋了如何檢索和修改數據庫信息,使用SQL Plus和SQL Developer,處理數據庫對象,撰寫PL/SQL程式等等。在這本書中,您將找到最新SQL功能和工具、性能優化技巧、高級查詢、Java支持和XML的深入介紹。這本書包含了您掌握SQL所需的一切。

- 探索SQL Plus和SQL Developer
- 使用SQL SELECT、INSERT、UPDATE和DELETE語句
- 撰寫PL/SQL程式
- 創建表、序列、索引、視圖和觸發器
- 撰寫包含複雜分析函數的高級查詢
- 創建數據庫對象和集合以處理抽象數據
- 使用大對象處理包含音樂和電影的多媒體文件
- 撰寫Java程式使用JDBC訪問Oracle數據庫
- 調整SQL語句以提高執行速度
- 探索Oracle Database 11g的最新功能,如PIVOT和UNPIVOT、回溯存檔等等