Product Description
Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.
From the Back Cover
Get The Ins-and-Outs of SQL and PL/SQL From an Oracle Expert
Perform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL/SQL programs. You’ll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL/SQL applications. Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10g in no time.
- Create tables, rows, records, columns, and fields
- Store text, numbers, dates, pictures, and soundfiles in tables and columns
- Define, manipulate, retrieve, and delete data, using SQL commands
- Select, sort, and filter records with SQL functions and procedures
- Write SQL commands to declare variables using anchored types
- Use SAVEPOINT and ROLLBACK commands to ensure multilevel undo
- Perform time-based and hierarchical data queries
- Edit and reuse commands in script files, using the SQL*Plus program
- Use PL/SQL views, sequences, procedures, functions, and packages
- Use triggers to automate auditing, security, and maintenance tasks
See all Product Description
With an Amazon.co.uk 
