Learning Oracle PL/SQL

By: Bill Pribyl, Steven Feuerstein

Write A Review

Paperback | 7 December 2001

At a Glance

Paperback
424 Pages

Dimensions(cm)
24.5 x 12.5 x 2.5

Paperback

RRP $95.00

$43.25

54%OFF

or 4 interest-free payments of $10.81 with

In Stock and Aims to ship in 1-2 business days

PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server.

Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials.

Topics include:

PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java? Syntax and examples of all core language constructs Creating, using, and reusing stored procedures, functions, and packages Building web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages) Securing PL/SQL programs against attack Benefits of third-party developer tools and integrated development environments Connecting PL/SQL to email, Java, and the Internet

Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i.

Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle PL/SQL Programming) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Programming & Scripting Languages Database Programming Databases Database Software Oracle Data Mining

Preface	p. xi
PL/SQL: What, When, and Where	p. 1
What Is PL/SQL?	p. 1
Why Use PL/SQL?	p. 9
What You Need to Get Started with PL/SQL	p. 15
Fundamentals	p. 20
PL/Lingo	p. 20
Running Your First PL/SQL Program	p. 22
Introduction to Program Structure	p. 26
Variables	p. 30
Common Operators	p. 37
Conditional Logic	p. 44
Executing in Circles: Loop Statements	p. 48
Code Formatting: Requirements and Guidelines	p. 54
Some Advanced Fundamentals	p. 56
Let's Code!	p. 62
Some Background on the Example	p. 62
A First Programming Exercise	p. 64
Retrieving a Book Count with a Function	p. 79
Make Your Code Resilient	p. 83
Using PL/SQL Packages to Organize Code	p. 89
Going to the Next Level	p. 100
Now What?	p. 104
Go Web, Young Man	p. 106
Introduction to HTML	p. 107
Using PL/SQL to Create Web Pages	p. 117
What Else?	p. 149
Fetch!	p. 151
What's the Big Deal?	p. 151
A Simple-Minded Approach to Retrieving One Row	p. 152
Retrieving More than One Row Using a Cursor	p. 154
Presenting Query Results via a Web Page	p. 165
Building a Web-Based Search Page Using Dynamic SQL	p. 170
Advanced Data Retrieval Topics	p. 187
Keeping House	p. 196
Organize Your Code	p. 196
Use Tools to Write Code Effectively	p. 209
Security: Keep the Bad Guys Out	p. 225
Oracle Security Primer	p. 226
Organizing Accounts to Improve Security	p. 235
Analyzing the Library System's Requirements	p. 246
Keeping a Trail of Database Changes	p. 252
Special Security Topics for PL/SQL Developers	p. 260
Communicating with the Outside World	p. 266
Sending Internet Email from PL/SQL	p. 267
Using the Mail Sender in the Library System	p. 272
Receiving Email Inside the Database	p. 275
Fetching Data from a Remote Web Site	p. 284
Integration with Other Languages	p. 296
Intermediate Topics and Other Diversions	p. 302
Riding the Software Lifecycle	p. 303
Lists o' Stuff (Collections) in PL/SQL	p. 305
Exception-Handling Packages	p. 317
Transaction Control	p. 322
The PL/SQL Compiler	p. 327
Managing Patron and Librarian Privileges	p. 331
Still More PL/SQL Features	p. 351
"Making Good" of Database Programming	p. 361
The Evidence	p. 361
The Problem	p. 363
Answering the Objections	p. 364
What to Do	p. 365
Glossary	p. 367
Index	p. 381
Table of Contents provided by Syndetics. All Rights Reserved.

Learning Oracle PL/SQL

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Python All-in-One For Dummies

3rd Edition

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Database Systems for Advanced Applications

29th International Conference, DASFAA 2024, Gifu, Japan, July 2-5, 2024, Proceedings, Part V

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part II

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part IV

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part I

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Social Research Methods

4th Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

R for Data Science

Import, Tidy, Transform, Visualize, and Model Data

Data and Analytics Strategy for Business

Unlock Data Assets and Increase Innovation with a Results-Driven Data Strategy

Hands-On Programming with R

Write Your Own Functions and Simulations

Generative Deep Learning

Teaching Machines To Paint, Write, Compose, and Play

Don't Make Me Think, Revisited

A Common Sense Approach to Web Usability

The Digital Humanities Coursebook

An Introduction to Digital Methods for Research and Scholarship

Mastering Shiny

Build Interactive Apps, Reports, and Dashboards Powered by R

Architecting Data and Machine Learning Platforms

Enable Analytics and Ai-Driven Innovation in the Cloud

SQL Tuning

O'Reilly Ser.

Information Modeling and Relational Databases

2nd Edition

Data Visualisation

2nd Edition - A Handbook for Data Driven Design

Practical Linear Algebra for Data Science

From Core Concepts to Applications Using Python

Data Analytics for Accounting ISE

3rd Edition

Advancing into Analytics

From Excel to Python and R

This product is categorised by