Oracle9i: The Complete Reference (Paperback)
Kevin Loney, George Koch
- 出版商: McGraw-Hill Education
- 出版日期: 2002-08-16
- 定價: $2,250
- 售價: 4.4 折 $999
- 語言: 英文
- 頁數: 1256
- 裝訂: Paperback
- ISBN: 0072225211
- ISBN-13: 9780072225211
-
相關分類:
Oracle
立即出貨(限量) (庫存=2)
買這商品的人也買了...
-
$460$391 -
$550$468 -
$2,160$2,052 -
$680$578 -
$980$833 -
$580$452 -
$2,230$2,119 -
$1,600$1,520 -
$620$527 -
$780$741 -
$760$600 -
$590$466 -
$480$408 -
$690$538 -
$420$357 -
$720$562 -
$720$612 -
$560$476 -
$560$476 -
$620$490 -
$990$782 -
$750$638 -
$560$476 -
$450$383 -
$480$379
商品描述
The Renowned Oracle Resource--Fully Updated for Oracle9i
Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. Youll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals.
- Use flashback queries to see data as it existed prior to commits
- Create, query, and manage external tables
- Create partitions, indexes, and tablespaces
- Execute and tune SQL queries
- Produce sophisticated reports using SQL*PLUS
- Load data from external files into Oracle database tables with SQL*Loader
- Create triggers, stored procedures, functions, and packages with PL/SQL
- Implement types, object views, and methods
- Develop robust database applications with SQLJ, JDBC, and XML
- Take advantage of the Oracle9i data dictionary and optimizer
- Tour the components of Oracle9i Application Server
(Oracle9iAS)
- Manage, tune, back up, and recover Oracle9i databases
- Learn anytime, anywhere with a 90-day Oracle University Professional
subscription. Details on CD-ROM
Bonus CD includes fully searchable electronic book, complete listings of all tables, and an Oracle9i Information & Documentation Kit featuring Release 2 New Features White Paper and selected documentation.
Contents
PART I: Critical Database
Concepts
1: Sharing Knowledge and
Success
2: The Dangers in a Relational
Database
3: The Basic Parts of Speech in
SQL
4: The Basics of Object-Relational
Databases
5: Introduction to Web-Enabled
Databases
PART II: SQL and SQL*PLUS
6: Basic SQL*PLUS Reports and Commands
7: Getting Text
Information and Changing It
8: Playing the
Numbers
9: Dates: Then, Now, and the
Difference
10: Conversion and Transformation
Functions
11: Grouping Things
Together
12: When One Query Depends upon
Another
13: Some Complex
Possibilities
14: Building a Report in
SQL*PLUS
15: Changing Data: insert, update, merge, and
delete
16: Advanced Use of Functions and
Variables
17: DECODE and CASE: if, then, and else in
SQL
18: Creating, Dropping, and Altering Tables and
Views
19: By What Authority?
20:
Changing the Oracle Surroundings
21: Using SQL*Loader to
Load Data
22: Accessing Remote
Data
23: Using Materialized Views
24: Using Oracle Text for Text Searches
25: Using
External Tables
26: Using Flashback
Queries
PART III: PL/SQL
27: An
Introduction to PL/SQL
28:
Triggers
29: Procedures, Functions, and
Packages
PART IV: Object-Relational
Databases
30: Implementing Types, Object Views, and
Methods
31: Collectors (Nested Tables and Varying
Arrays)
32: Using Large Objects
33: Advanced Object-Oriented Concepts
PART V: Java in
Oracle
34: An Introduction to Java
35: JDBC and SQLJ Programming
36: Java Stored
Procedures
PART VI: Hitchhiker’s
Guides
37: The Hitchhiker’s Guide to the Oracle9i Data
Dictionary
38: The Hitchhiker’s Guide to the Oracle
Optimizer
39: The Hitchhiker’s Guide to
Oracle9iAS
40: The Hitchhiker’s Guide to Database
Administration
41: The Hitchhiker’s Guide to XML in
Oracle
PART VII: Alphabetical
Reference
Reference