|
The Wonders of Oracle9i PL/SQL
The
improvements revealed in the Oracle9i PL/SQL language demonstrate
clearly that Oracle is committed to the PL/SQL language, in terms of
both enhanced performance and feature robustness. We will explore
some of the most important advances in Oracle9i PL/SQL, including:
- Support for inheritance in Oracle object
types: You can now (finally) define "class hierarchies"
with object types, which will make Oracle's object model much more
attractive and useful.
- Table functions and cursor expressions: You
can now call a function from within the FROM clause of a SQL
query, greatly expanding the flexibility and in some cases
performance of your application (most especially in data
warehousing applications).
- Enhanced date and timestamp functionality:
You can now define timestamps with fractional second precision to
9 digits. The new INTERVAL datatype allows you to store and
manipulate with great accuracy the amount of time between two
dates or timestamps.
Leverage Java from
within PL/SQL
This section includes a brief primer on
writing simple Java classes, followed by a more in-depth look at how
to take advantage of Java functionality from within PL/SQL programs.
As Steven says in his class, "We all need to learn Java, but it
turns out that you don't need to know very MUCH Java to start using
it inside PL/SQL programs."
Work with XML data inside PL/SQL
XML is
rapidly becoming the de facto standard for the transmission of data
between the many distributed components that are deployed via the
Internet to solve pressing business needs. Oracle has moved
aggressively to support XML inside the database. This seminar will
introduce you to the basics of XML documents and show how to parse,
manipulate and transform data between tables and XML documents.
Delight in the wonders of Native Dynamic
SQL
In Oracle8i, Oracle introduced a new way of
designing and executing dynamically (run-time) constructed SQL and
PL/SQL statements: native dynamic SQL or NDS. With NDS, you will
find dynamic SQL much easier and faster to write and execute. We
will explore the new EXECUTE IMMEDIATE and OPEN FOR statements and
entertain ourselves with all the magical things you can do with NDS.
|
