Beginning Oracle PL/SQL by Donald Bales

By Donald Bales

Beginning Oracle PL/SQL will get you all started in utilizing the integrated language that each Oracle developer and database administrator needs to be aware of. Oracle Database is brim-full of integrated software beneficial properties which are unfastened for the utilizing, and PL/SQL is your price tag to studying approximately and utilizing these good points out of your personal code. With it, you could centralize enterprise common sense within the database, you could offload program good judgment, and you may automate database- and application-administration projects.

Author Don Bales presents in Beginning Oracle PL/SQL a fast paced and example-filled instructional. study from Don’s large adventure to find the main regular features of PL/SQL, with out losing time on vague and out of date positive aspects.

The writer takes his 20+ years of expertise and a wealth of facts he is accumulated on PL/SQL utilization over these years and applies the 80/20 rule: hide what is so much wanted and utilized by PL/SQL pros and stay away from what is now not invaluable! the result's a booklet that covers all of the key positive aspects of PL/SQL with out wasting precious time discussing esoteric and out of date elements of the language. research what rather concerns, for you to get to paintings feeling convinced with what you recognize approximately PL/SQL.

  • Covers the main themes that subject, together with variables and datatypes, executing statements, operating with cursors, bulk operations, real-world items, debugging, checking out, and more.

  • Teaches you to jot down production-level, object-oriented PL/SQL. you will discover relational PL/SQL, yet not like so much different books at the topic, this one emphasizes using PL/SQLs object-oriented good points as well.

  • Guides you in operating via genuine examples of utilizing of PL/SQL. you are going to examine PL/SQL by way of utilizing it to real-world company difficulties, now not by way of heavy theory.

Show description

Read Online or Download Beginning Oracle PL/SQL PDF

Best oracle books

Oracle Database 11g New Features

FOREWORD through Tom Kyte Your Must-Have consultant to every thing New in Oracle Database 11gRealize the entire capability of Oracle Database 11g with support from the specialists. Written by way of Robert G. Freeman, and with insightful remark all through from Arup Nanda, this Oracle Press advisor deals complete info at the architectural alterations, database management improvements, availability and restoration revisions, protection improvements, and programming recommendations.

Oracle Database 10g, A Beginner's Guide

Presents starting DBAs and builders with an exceptional origin within the database management and programming fundamentals had to embark on an Oracle occupation. the focal point is on Oracle Database 10g, yet you’ll get the basics appropriate to all Oracle database releases.

Pro Oracle Database 12c Administration

Professional Oracle Database 12c management is a booklet fascinated about effects. writer Darl Kuhn attracts from a good of expertise over a decade deep to put out real-world options that bring about luck as an Oracle Database administrator. He provides transparent reasons on how you can practice serious initiatives. He weaves in idea the place worthwhile with no bogging you down in unneeded aspect.

Oracle Application Express for Mobile Web Applications

Oracle software convey is celebrated within the Oracle group as a useful gizmo for growing internet purposes compatible for computer browsers. beneficial properties have now been additional to open up the realm of cellular shopping, bringing the simplicity and expressiveness of Appliction show to endure in constructing functions to run with an almost-native feel and appear on systems akin to iOS, Android, and home windows mobilephone.

Extra info for Beginning Oracle PL/SQL

Sample text

END: Every PL/SQL block ends with the keyword END. Anonymous Blocks We’ll start with an anonymous PL/SQL block. It’s called anonymous because it’s not going to be saved in the database, so it will never have a name. In practice, you won’t find yourself using anonymous blocks in production, but you’ll use them throughout the development process. They’re perfect for creating test units that you’ll eventually move into your stored PL/SQL blocks. You’ll learn more about that in Chapter 8. For now, let’s look at an example.

An Example of Nesting Blocks As you saw, the test unit for procedure pl() in Listing 2-7 stopped executing after line 28 because line 28 caused the following error: ORA-20000: ORU-10028: line length overflow, limit of 32767 bytes per line 48 Chapter 2 ■ Blocks, Functions, and Procedures In Listing 2-8, I’ve recoded the pl() test unit. This time, I’ve blocked the lines that I expect to fail, so the program will catch any raised exceptions and continue processing the code all the way to the end of the source code listing.

Listing 1-22. sql 1 2 3 SELECT name FROM authors ORDER BY name; NAME ------------------CHRIS J DATE EDGAR F CODD HUGH DARWEN 21 Chapter 1 ■ Relational SQL Listing 1-22 actually shows the query (SELECT statement) executed in SQL*Plus, along with the database’s response. The syntax of the SELECT statement in Listing 1-22 is as follows: SELECT , , FROM [ORDER BY ] where is one of the columns in the table listed, is the table to query, and is one or more columns by which to sort the results.

Download PDF sample

Rated 4.06 of 5 – based on 19 votes