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

Oracle Database 10G Pl/Sql 101

Oracle Press

Paperback

Published: 31st August 2004
Ships: 7 to 10 business days
7 to 10 business days
RRP $77.95
$70.50
10%
OFF
if ordered within

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.

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