Both Oracle9i Database Release 1 and Release 2 introduced powerful new PL/SQL language features. These allow you to implement your required functionality using compact syntax backed by an efficient implementation. This paper will examine some very common programming tasks. We'll remind you how you would have had to implement them in versions prior to Oracle9i Database. And we'll show you the new recommended approach. You'll see that you need fewer lines of code. We'll explain why the program will be more efficient.
Another reason you often used to write more code than you wanted was to call Dbms_Output.Put_Line, the de facto debugging tool of choice. We'll demonstrate how you can now forget that and debug your programs interactively using Oracle9i JDeveloper's graphical PL/SQL development environment.
Bookmark
