Oracle for Professionals - Covers Oracle 9i, 10g and 11g W CD

Front Cover
Shroff Publishers, 2008 - Oracle (Computer file) - 1343 pages
2 Reviews
Covers Oracle 9i, 10g & 11g Designed for new and experienced developers, this book is an essential guide for putting Oracle SQL and PL/SQL to work. It provides all of the basics you would expect to find in an introductory text and at the same time serves those who want to harness the unexploited, overlooked power of Oracle SQL and PL/SQL with an easy to follow format and numerous real examples based on most commonly used business database models. It delves deeply into new features found in Oracle Database 11g, the next incarnation of Oracle`s flagship database management system along with existing features found in Oracle Database 9i and 10g.
 

What people are saying - Write a review

User Review - Flag as inappropriate

It's most use full guide for me.
Thank you.....

User Review - Flag as inappropriate

great book for oracle beginners with clear concept & lucid examples

Contents

OVERVIEW OF ORACLE DATABASE
1
ORACLE DATABASE ARCHITECTURE
13
3
23
TESTING THE INSTALLATION
56
AUTOMATICALLY STARTING ORACLE SERVICE ON LINUX
67
TABLESPACE AND USER MANAGEMENT
87
USING SQL PLUS
103
SQL DEVELOPER
147
VIEWS
621
CLUSTERS
641
SEQUENCES
653
BEYOND THE BASICS
671
DATABASE OBJECTS AND COLLECTIONS
683
ORACLE TEXT
719
WORKING WITH XML
739
PLSQL
765

ORACLE SAMPLE SCHEMAS
175
BASICS OF
181
DATA TYPES
191
WORKING WITH DATABASE TABLES
201
MUTLITABLE INSERT STATEMENTS
245
MERGING ROWS
257
SYNONYMS
267
DATA CONSTRAINTS
283
WORKING WITH DATA
315
USING CHARACTERSTRING FUNCTIONS
345
USING NUMERIC FUNCTIONS
379
USING DATE FUNCTIONS
399
GROUPING DATA
419
SUBQUERIES
431
JOINS
447
UNION INTERSECT AND MINUS
469
ANALYTIC FUNCTIONS
483
MODELING DATA
509
HIERARCHIAL SQL QUERIES
527
IF THEN AND ELSE IN ORACLE
541
CROSS TAB VIEWS USING PIVOTUNPIVOT OPERATORS
549
REGULAR EXPRESSIONS
559
WORKING WITH ROWID AND ROWNUM
589
SQL PERFORMANCE TUNNING
603
TRANSACTIONS
789
CURSORS
801
PROCEDURES AND FUNCTIONS
837
PACKAGES
855
TRIGGERS
873
AUTOMATICALLY GENERATING AND ASSIGNING PRIMARY KEY VALUES
909
DYNAMIC SQL
919
DML ERROR LOGGING
939
BACKUP RESTORE AND DATA LOADING
951
DATA PUMP IMPDB AND EXPDB
965
SQLLOADER
997
APPLICATION DEVELOPMENT
1013
PHP
1055
PROCC++
1101
SCRIPTING IN ORACLE
1123
PLSQLSCRIPTS
1135
DATA WAREHOUSE
1149
IMPLEMENTING A DATA INTEGRATION SOLUTION
1156
Identify The Target Schema
1175
APPENDIX
1207
B INSTALLING ORACLE DATABASE 10g EXPRESS EDITION
1271
On Linux
1292
INTERVIEW QUESTIONS
1303
Copyright

Common terms and phrases

Bibliographic information