Oracle Database 10g The Complete Reference

Oracle Database 10g:The Complete Reference:Pub. Date: August 2004 |Publisher: McGraw-Hill Companies |Format: pdf |Series: Osborne ORACLE Press Series |ISBN-13: 9780072253511 |ISBN: 0072253517 |Edition Number: 1 |Size:6mb www.woebooks.com

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Download links www.woebooks.com

Table of Contents

Pt. I Critical database concepts

1 Oracle Database 10g architecture options 3

2 Installing Oracle Database 10g and creating a database 11

3 Upgrading to Oracle Database 10g 27

4 Planning Oracle applications - approaches, risks, and standards 37

Pt. II SQL and SQL* Plus

5 The basic parts of speech in SQL 73

6 Basic SQL Plus* reports and commands 101

7 Getting text information and changing it 123

8 Searching for regular expressions 149

9 Playing the numbers 163

10 Dates : then, now, and the difference 189

11 Conversion and transformation functions 217

12 Grouping things together 229

13 When one query depends upon another 243

14 Some complex possibilities 261

15 Changing data : insert, update, merge, and delete 279

16 DECODE and CASE : if, then, and else in SQL 297

17 Creating and managing tables, views, indexes, clusters, and sequences 311

18 Basic Oracle security 345

Pt. III Beyond the basics

19 Advanced security - virtual private databases 371

20 Working with tablespaces 383

21 Using SQL* Loader to load data 391

22 Using data pump export and import 405

23 Accessing remote data 423

24 Using materialized views 437

25 Using Oracle Text for text searches 459

26 Using external tables 477

27 Using flashback queries 493

28 Flashback - table and databases 503

Pt. IV Pl/Sql

29 An introduction to PL/SQL 513

30 Triggers 535

31 Procedures, functions, and packages 555

32 Using native dynamic SQL and DBMSöSQL 575

Pt. V Object-relational databases

33 Implementing types, object views, and methods 587

34 Collectors (nested tables and varying arrays) 603

35 Using large objects 619

36 Advanced object-oriented concepts 647

Pt. VI Java in Oracle

37 An introduction to Java 667

38 JDBC programming 685

39 Java stored procedures 697

Pt. VII Clustered Oracle - the grid

40 Oracle real application clusters 709

41 Grid architecture and management 719

Pt. VIII Hitchhiker's guides

42 The hitchhiker's guide to the Oracle data dictionary 731

43 The Hitchhiker's guide to tuning applications and SQL 791

44 Case studies in tuning 835

45 The hitchhiker's guide to Oracle Application Server 10g 845

46 The hitchhiker's guide to database administration 885

47 The hitchhiker's guide to XML in Oracle 921