0072123648 9780072123647 0072123621 9780072123623 007212363X CD 9780072123630 CD
Alternate Call Number
D 733 LON.O(10)
Summary
Master all the powerful features of Oracle8i, the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Written by best-selling Oracle author, Kevin Loney, and a former senior vice president of Oracle Corporation, George Koch, Oracle8i: The Complete Reference covers all the components of this robust product. You'll learn key relational and object-relational database concepts; SQL, PL/SQL, SQLJ, and Java programming techniques; backup, recovery, and tuning methods; and much more.
Note
Includes a fully searchable electronic version of the book on CD-ROM with reusable code;. Covers releases 8i, 8.0x, and 7.x. Sottotit. della cop.: the most definitive resource available on Oracle8i. På omslaget: covers releases 8i, 8.0x and 7.x. Sur la couv.: Covers releases 8i, 8.0.x, and 7.x.
Formatted Contents Note
pt. 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 pt. II. SQL and SQL*PLUS 6. Basic SQLPLUS 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 SQLPLUS 15. Changing Data: insert, update, and delete 16. Advanced Use of Functions and Variables 17. DECODE: Amazing Power in a Single Word 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. Snapshots and Materialized Views 24. Using interMedia Text for Text Searches pt. III. PL/SQL 25. An Introduction to PL/SQL 26. Triggers 27. Procedures, Functions, and Packages pt. IV. Object-Relational Databases 28. Implementing Types, Object Views, and Methods 29. Collectors (Nested Tables and Varying Arrays) 30. Using Large Objects 31. Advanced Object-Oriented Concepts pt. V. Java in Oracle 32. An Introduction to Java 33. JDBC and SQLJ Programming 34. Java Stored Procedures pt. VI. Hitchhiker's Guides 35. The Hitchhiker's Guide to the Oracle8i Data Dictionary 36. The Hitchhiker's Guide to the Oracle Optimizer 37. A Brief Introduction to WebDB 38. Beginner's Guide to Database Administration pt. VII. Designing for Performance 39. Good Design Has a Human Touch 40. Performance and Design 41. The Ten Commandments of Humane Design.