Rick Greenwald, David C. Kreines

Oracle in a Nutshell (eBook, PDF)

A Desktop Quick Reference

• Format: PDF

Produktbeschreibung

Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes:Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options.Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database.Oracle Tools--Commands provided with SQLPlus, SQLLoader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack).Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 928
• Erscheinungstermin: 18. Dezember 2002
• Englisch
• ISBN-13: 9781491942956
• Artikelnr.: 43833450

Autorenporträt

has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has been a principal author of ten books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. In addition to Oracle in a Nutshell, Rick's books include Oracle Essentials: Oracle9i, Oracle8i, and Oracle8 (principal author with Robert Stackowiak and Jonathan Stern, O'Reilly & Associates, 2001), Oracle Power Objects Developer's Guide (principal author with Kasu Sista and Richard Finklestein, Oracle Press, 1995); Mastering Oracle Power Objects (principal author with Robert Hoskins, O'Reilly & Associates, 1996); Using Oracle Web Server (principal author with many others, Que Publishing, 1997); The Oracle WebDB Bible (principal author with Jim Milbery, IDG Books Worldwide, 1999); and Administering Exchange Server (principal author with Walter Glenn, Microsoft Press, 1999).

Inhaltsangabe

Dedication
Preface
Which Platform and Version?
Structure of This Book
Conventions Used in This Book
Comments and Questions
Acknowledgments
Foundations
Chapter 1: Architecture and Packaging
1.1 Oracle Instances and Databases
1.2 The Components of a Database
1.3 The Components of an Instance
1.4 Oracle Versions
1.5 Oracle Packaging
Chapter 2: Configuration
2.1 Parameter Files and Types
2.2 Initialization Parameters
Chapter 3: Concurrency
3.1 Concurrency Concepts
3.2 Oracle and Concurrent User Access
Chapter 4: Security
4.1 Authentication
4.2 Profiles
4.3 Privileges
4.4 Privileges and Users
4.5 Roles
4.6 Auditing
4.7 Other Security Features
Chapter 5: Networking
5.1 Oracle Networking Fundamentals
5.2 Configuration Files
5.3 Networking Management Utilities
Chapter 6: Data Dictionary
6.1 Static Data Dictionary Views
6.2 Dynamic Data Dictionary Views
Languages
Chapter 7: SQL
7.1 Common Keywords and Identifiers
7.2 Common SQL Clauses
7.3 Data Definition Statements
7.4 Data Manipulation Statements
Chapter 8: Functions
8.1 Common Keywords and Clauses
8.2 Aggregate and Analytic Functions
8.3 Numeric Functions
8.4 Character Functions
8.5 Date and Time Functions
8.6 Conversion Functions
8.7 Object Functions
8.8 XML Functions
8.9 Miscellaneous Functions
Chapter 9: PL/SQL
9.1 PL/SQL Fundamentals
9.2 Header Section
9.3 Declaration Section
9.4 Execution Section
9.5 Exception Section
9.6 Pragmas
9.7 Program Units
9.8 Packages
9.9 Triggers
9.10 Calling PL/SQL Functions in SQL
9.11 Native Compilation of PL/SQL
9.12 External Procedures
9.13 Java and PL/SQL
Chapter 10: PL/SQL Packages
10.1 DBMS_ALERT
10.2 DBMS_APPLICATION_INFO
10.3 DBMS_APPLY_ADM
10.4 DBMS_AQ
10.5 DBMS_AQADM
10.6 DBMS_AQELM
10.7 DBMS_CAPTURE_ADM
10.8 DBMS_DDL
10.9 DBMS_DEBUG
10.10 DBMS_DEFER
10.11 DBMS_DEFER_QUERY
10.12 DBMS_DEFER_SYS
10.13 DBMS_DESCRIBE
10.14 DBMS_DISTRIBUTED_TRUST_ADMIN
10.15 DBMS_FGA
10.16 DBMS_FLASHBACK
10.17 DBMS_HS
10.18 DBMS_HS_PASSTHROUGH
10.19 DBMS_IOT
10.20 DBMS_JOB
10.21 DBMS_LDAP
10.22 DBMS_LIBCACHE
10.23 DBMS_LOB
10.24 DBMS_LOCK
10.25 DBMS_LOGMNR
10.26 DBMS_LOGMNR_CDC_PUBLISH
10.27 DBMS_LOGMNR_CDC_SUBSCRIBE
10.28 DBMS_LOGMNR_D
10.29 DBMS_LOGSTNDBY
10.30 DBMS_METADATA
10.31 DBMS_MGWADM
10.32 DBMA_MGWMSG
10.33 DBMS_MVIEW
10.34 DBMS_OBFUSCATION_TOOLKIT
10.35 DBMS_ODCI
10.36 DBMS_OFFLINE_OG
10.37 DBMS_OFFLINE_SNAPSHOT
10.38 DBMS_OLAP
10.39 DBMS_ORACLE_TRACE_AGENT
10.40 DBMS_ORACLE_TRACE_USER
10.41 DBMS_OUTLN
10.42 DBMS_OUTLN_EDIT
10.43 DBMS_OUTPUT
10.44 DBMS_PCLXUTIL
10.45 DBMS_PIPE
10.46 DBMS_PROFILER
10.47 DBMS_PROPAGATION_ADM
10.48 DBMS_RANDOM
10.49 DBMS_RECTIFIER_DIFF
10.50 DBMS_REDEFINITION
10.51 DBMS_REFRESH
10.52 DBMS_REPAIR
10.53 DBMS_REPCAT
10.54 DBMS_REPCAT_ADMIN
10.55 DBMS_REPCAT_AUTH
10.56 DBMS_REPCAT_INSTANTIATE
10.57 DBMS_REPCAT_RGT
10.58 DBMS_REPUTIL
10.59 DBMS_RESOURCE_MANAGER
10.60 DBMS_RESOURCE_MANAGER_PRIVS
10.61 DBMS_RESUMABLE
10.62 DBMS_RLS
10.63 DBMS_ROWID
10.64 DBMS_RULE
10.65 DBMS_RULE_ADMIN
10.66 DBMS_SESSION
10.67 DBMS_SHARED_POOL
10.68 DBMS_SNAPSHOT
10.69 DBMS_SPACE
10.70 DBMS_SPACE_ADMIN
10.71 DBMS_SQL
10.72 DBMS_STATS
10.73 DBMS_STORAGE_MAP
10.74 DBMS_STREAM_ADM
10.75 DBMS_STREAMS
10.76 DBMS_SYSTEM
10.77 DBMS_TRACE
10.78 DBMS_TRANSACTION
10.79 DBMS_TRANSFORM
10.80 DBMS_TTS
10.81 DBMS_TYPES
10.82 DBMS_UTILITY
10.83 DBMS_WM
10.84 DBMS_XDB
10.85 DBMS_XDBT
10.86 DBMS_XDB_VERSION
10.87 DBMS_XMLDOM
10.88 DBMS_XMLGEN
10.89 DBMS_XMLPARSER
10.90 DBMS_XMLQUERY
10.91 DBMS_XMLSAVE
10.92 DBMS_XMLSCHEMA
10.93 DBMS_XPLAN
10.94 DBMS_XSLPROCESSOR
10.95 DEBUG_EXTPROC
10.96 OUTLN_PKG
10.97 UTL_COLL
10.98 UTL_ENCODE
10.99 UTL_FILE
10.100 UTL_HTTP
10.101 UTL_INADDR
10.102 UTL_RAW
10.103 UTL_REF
10.104 UTL_SMTP
10.105 UTL_TCP
10.106 UTL_URL
Chapter 11: Java and Oracle
11.1 Java Drivers
11.2 Java in the Oracle Database
11.3 Data Mapping
11.4 SQLJ
11.5 JDBC
Tools and Utilities
Chapter 12: SQL*Plus
12.1 Running SQL*Plus
12.2 Formatting Text Reports
12.3 SQL*Plus Format Elements
12.4 Commands
Chapter 13: Export and Import
13.1 Export/Import Fundamentals
13.2 Common Parameters
13.3 Export-Only Parameters
13.4 Import-Only Parameters
Chapter 14: SQL*Loader
14.1 Running SQL*Loader
14.2 Command-Line Parameters
14.3 Control File
Chapter 15: Backup and Recovery
15.1 Backup and Recovery Fundamentals
15.2 User-Managed Backup and Recovery
15.3 Recovery Manager (RMAN)
Chapter 16: Enterprise Manager
16.1 Architecture
16.2 Running Enterprise Manager
16.3 Enterprise Manager Interface
16.4 Enterprise Manager Administration
16.5 Expansion Packs
16.6 OEMUTIL
Chapter 17: Performance
17.1 SQL Optimization
17.2 EXPLAIN PLAN
17.3 TKPROF
17.4 AUTOTRACE
17.5 Statistics Collection
Appendixes
Datatypes
Scalar Datatypes
Collection Datatypes
Reference Datatypes
Expressions, Operators, and Conditions
Expressions
Operators
Conditions
Numeric Formats
Date Formats
Additional Resources
Web Sites
Books
Colophon

Rezensionen

"In short this is a well-written book that provides a wealth of information in a highly condensed form." - James Robert, Cvu, August 2003