+612 9045 4394
Oracle Database 10G Pl/Sql 101 : Oracle Press - Christopher Allen

Oracle Database 10G Pl/Sql 101

Oracle Press

Paperback Published: 31st August 2004
ISBN: 9780072255409
Number Of Pages: 416

Share This Book:


Ships in 7 to 10 business days

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Acknowledgmentsp. xiii
Introductionp. xv
Database Basics
Introduction to Databasesp. 3
What Exactly Is a Database?p. 4
How Is a Database Different from a Spreadsheet?p. 7
How Will Knowing This Help You?p. 11
History of SQLp. 12
SQL Command Categoriesp. 13
Chapter Summaryp. 15
Chapter Questionsp. 16
Answers to Chapter Questionsp. 18
Storing and Retrieving Data: The Basicsp. 21
Putting Your Toe in the Waterp. 22
Creating Tablesp. 26
Inserting Data--Additional Techniquesp. 41
Viewing Data--Additional Techniquesp. 46
Chapter Summaryp. 54
Chapter Questionsp. 56
Answers to Chapter Questionsp. 58
Advanced Data Manipulationp. 61
Limit Which Records You Selectp. 62
Change the Order of Recordsp. 72
Show Only Unique Valuesp. 75
Select from DUALp. 78
Modify Data In a Tablep. 78
Remove Records from a Tablep. 81
Transaction Controlp. 83
Chapter Summaryp. 89
Chapter Questionsp. 90
Answers to Chapter Questionsp. 92
Controlling SQL*Plusp. 93
Edit Prior Commandsp. 94
Copy and Pastep. 99
Clear the SQL*Plus Screenp. 102
Customize the SQL*Plus Environmentp. 103
Produce More Readable Outputp. 106
Spool Output to Diskp. 113
SQL Script Filesp. 114
Chapter Summaryp. 118
Chapter Questionsp. 119
Answers to Chapter Questionsp. 120
Advanced SQL
SQL Functionsp. 123
Commonly Used Single-Row Functionsp. 125
Commonly Used Group Functionsp. 174
Chapter Summaryp. 179
Chapter Questionsp. 180
Answers to Chapter Questionsp. 182
Using Indexes and Constraintsp. 183
Indexesp. 186
Ensure Data Integrity: Constraintsp. 195
Relationships Between Tablesp. 211
Write Subqueriesp. 230
Chapter Summaryp. 235
Chapter Questionsp. 236
Answers to Chapter Questionsp. 238
Other Useful Oracle Techniquesp. 239
Transfer Data Between Tablesp. 244
Rename Tablesp. 253
Alter a Table's Structurep. 253
Viewsp. 260
Other Database Objectsp. 264
Chapter Summaryp. 273
Chapter Questionsp. 274
Answers to Chapter Questionsp. 277
Create Programs Using PL/SQL
Introduction to PL/SQLp. 281
What Is PL/SQL?p. 282
Structure of a PL/SQL Blockp. 289
Create a Simple PL/SQL Procedurep. 293
PL/SQL Variables and Constantsp. 296
Control Structures in PL/SQLp. 300
Error Handlingp. 313
Chapter Summaryp. 319
Chapter Questionsp. 319
Answers to Chapter Questionsp. 321
More PL/SQL Toolsp. 323
Coding Conventionsp. 327
More on PL/SQL and Oracle Server Interactionp. 329
Timing Operationsp. 341
PL/SQL Packagesp. 345
Triggersp. 351
XMLp. 359
Chapter Summaryp. 359
Chapter Questionsp. 360
Answers to Chapter Questionsp. 361
Glossary of Common Oracle Termsp. 363
Indexp. 375
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072255409
ISBN-10: 0072255404
Series: Oracle Press
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 416
Published: 31st August 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 23.2 x 18.9  x 2.3
Weight (kg): 0.71
Edition Number: 1