O'Reilly logo

Java™ Oracle® Database Development by David J. Gallardo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. PL/SQL

If you know ADA, Oracle PL/SQL will seem very familiar. If you don't, don't be put off by the comparison with ADA. First of all, PL/SQL is a much smaller language than ADA, and you'll quickly get used to the language features that may make it look strange at first.

What sets PL/SQL apart from other languages, however, is that it is well integrated with Oracle and SQL. In fact, you can generally include SQL statements directly in PL/SQL code. These SQL statements can include PL/SQL variables for either input or output. One important limitation, however, is that SELECT statements returning multiple rows need to be handled differently—as we will see later.

The basic unit of programming in PL/SQL, corresponding to a method in Java, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required