This book is for you if you: Want to be either an Oracle administrator or developer; Need a tutorial that takes you from no knowledge to mastery of the Oracle database; Understand the underlying concepts behind relational databases; Have experience of basic SQL. What you will learn from this book: By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. We will cover: Core Oracle terminology, tools, concepts, and architecture; The functionality of the different versions and editions of Oracle (8, 8i, and 9i); Basic and advanced Oracle SQL; Mastering SQL*Plus as an Oracle development tool; Understanding tables, indexes, transactions and concurrency, views, triggers, and objects; Using PL/SQL to write and package procedural code in the database; Securing your Oracle applications; Evaluating performance and tuning your Oracle application; A SQL Toolkit of useful scripts that you can use in your database; Case studies that apply this knowledge to create two practical Oracle applications... 571 AUTOTRACE tool statistics, 722 SQL-Plus buffer, 336 EDlT command compared to, 337 SQL-Plus interface, 23, ... 14 manual installation of sample schemas, 1028 PROMPT command, 324 SAVE command, 337 screenshot example, anbsp;...
|Title||:||Beginning Oracle Programming|
|Publisher||:||Apress - 2002|