Oracle Database 10g PL/SQL 101 (Oracle Press)

3.18 avg rating
( 11 ratings by GoodReads )
 
9780072255409: Oracle Database 10g PL/SQL 101 (Oracle Press)

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.

"synopsis" may belong to another edition of this title.

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

About the Author:

Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Christopher Allen
Published by McGraw-Hill Education 2004-08-10 (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Paperback Quantity Available: 1
Seller
Ebooksweb COM LLC
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education 2004-08-10, 2004. Paperback. Book Condition: New. 1. 0072255404. Bookseller Inventory # Z0072255404ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.26
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Christopher Allen
Published by McGraw-Hill Education
ISBN 10: 0072255404 ISBN 13: 9780072255409
New PAPERBACK Quantity Available: 1
Seller
Vital Products COM LLC
(southampton, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072255404. Bookseller Inventory # Z0072255404ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.26
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Christopher Allen
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Paperback. Book Condition: New. book. Bookseller Inventory # 0072255404

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.56
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Christopher Allen
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0072255404

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.44
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

Christopher Allen
Published by McGraw-Hill Education (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Quantity Available: > 20
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2004. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780072255409

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.81
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

6.

Christopher Allen
Published by McGraw-Hill Education
ISBN 10: 0072255404 ISBN 13: 9780072255409
New PAPERBACK Quantity Available: > 20
Seller
Movie Mars
(Indian Trail, NC, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0072255404 Brand New Book. Ships from the United States. 30 Day Satisfaction Guarantee!. Bookseller Inventory # 15556244

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 31.17
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Christopher Allen
Published by McGraw-Hill Education - Europe, United States (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Paperback Quantity Available: 10
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2004. Paperback. Book Condition: New. 226 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAC9780072255409

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 35.34
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Christopher Allen
Published by McGraw-Hill Education (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Quantity Available: 1
Seller
Nearfine Books
(Brooklyn, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2004. Book Condition: new. Shiny and new! Expect delivery in 20 days. Bookseller Inventory # 9780072255409-1

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 31.35
Convert Currency

Add to Basket

Shipping: US$ 4.00
Within U.S.A.
Destination, Rates & Speeds

9.

Christopher Allen
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Quantity Available: 5
Seller
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description Book Condition: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Bookseller Inventory # NU-ING-00418851

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 32.24
Convert Currency

Add to Basket

Shipping: US$ 3.73
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Christopher Allen
Published by McGraw-Hill Education - Europe, United States (2004)
ISBN 10: 0072255404 ISBN 13: 9780072255409
New Paperback Quantity Available: 10
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2004. Paperback. Book Condition: New. 226 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAC9780072255409

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 36.38
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book