Oracle Database 10g PL/SQL 101 / Edition 1
  • Alternative view 1 of Oracle Database 10g PL/SQL 101 / Edition 1
  • Alternative view 2 of Oracle Database 10g PL/SQL 101 / Edition 1

Oracle Database 10g PL/SQL 101 / Edition 1

4.0 1
by Christopher Allen
     
 

ISBN-10: 0072255404

ISBN-13: 9780072255409

Pub. Date: 08/10/2004

Publisher: McGraw-Hill Professional Publishing

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.

See more details below

Overview

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.

Product Details

ISBN-13:
9780072255409
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/10/2004
Series:
Oracle Press Series
Pages:
416
Product dimensions:
7.30(w) x 9.00(h) x 0.81(d)

Related Subjects

Table of Contents

Acknowledgmentsxiii
Introductionxv
Part IDatabase Basics
1Introduction to Databases3
What Exactly Is a Database?4
How Is a Database Different from a Spreadsheet?7
How Will Knowing This Help You?11
History of SQL12
SQL Command Categories13
Chapter Summary15
Chapter Questions16
Answers to Chapter Questions18
2Storing and Retrieving Data: The Basics21
Putting Your Toe in the Water22
Creating Tables26
Inserting Data--Additional Techniques41
Viewing Data--Additional Techniques46
Chapter Summary54
Chapter Questions56
Answers to Chapter Questions58
3Advanced Data Manipulation61
Limit Which Records You Select62
Change the Order of Records72
Show Only Unique Values75
Select from DUAL78
Modify Data In a Table78
Remove Records from a Table81
Transaction Control83
Chapter Summary89
Chapter Questions90
Answers to Chapter Questions92
4Controlling SQL*Plus93
Edit Prior Commands94
Copy and Paste99
Clear the SQL*Plus Screen102
Customize the SQL*Plus Environment103
Produce More Readable Output106
Spool Output to Disk113
SQL Script Files114
Chapter Summary118
Chapter Questions119
Answers to Chapter Questions120
Part IIAdvanced SQL
5SQL Functions123
Commonly Used Single-Row Functions125
Commonly Used Group Functions174
Chapter Summary179
Chapter Questions180
Answers to Chapter Questions182
6Using Indexes and Constraints183
Indexes186
Ensure Data Integrity: Constraints195
Relationships Between Tables211
Write Subqueries230
Chapter Summary235
Chapter Questions236
Answers to Chapter Questions238
7Other Useful Oracle Techniques239
Transfer Data Between Tables244
Rename Tables253
Alter a Table's Structure253
Views260
Other Database Objects264
Chapter Summary273
Chapter Questions274
Answers to Chapter Questions277
Part IIICreate Programs Using PL/SQL
8Introduction to PL/SQL281
What Is PL/SQL?282
Structure of a PL/SQL Block289
Create a Simple PL/SQL Procedure293
PL/SQL Variables and Constants296
Control Structures in PL/SQL300
Error Handling313
Chapter Summary319
Chapter Questions319
Answers to Chapter Questions321
9More PL/SQL Tools323
Coding Conventions327
More on PL/SQL and Oracle Server Interaction329
Timing Operations341
PL/SQL Packages345
Triggers351
XML359
Chapter Summary359
Chapter Questions360
Answers to Chapter Questions361
Glossary of Common Oracle Terms363
Index375

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Oracle Database 10g PL/SQL 101 4 out of 5 based on 0 ratings. 1 reviews.
Anonymous More than 1 year ago
I liked the information that the book provided and found it easy to follow. I thought the author provided a little too much history as far as SQL; the first 7 chapters covered more SQL than PL/SQL. But I found this book to be informative and would buy it again.