OOW 2012: Is PL/SQL still alive?
Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”.
The room was packed.
For the upcoming release of the Oracle 12c database the enhancements were broken into three areas:
- Improved PL/SQL and SQL interoperability
In the current version of the Oracle database you needed a Nested Table or Varray Type defined at schema level in order to be able to use it in the TABLE operator.
This is no longer necessary, it can be a PL/SQL declared type.
The types that can be used as bind variables has been extended: Boolean, Nested Tables can be used as bindvariable in Dynamic SQL.
Subquery Factoring (the With clause if you will) can hold private functions, the use case presented for this: pretty print an integer in K, M, G, T.
Using userdefined PL/SQL functions in a SQL statement is not advisable, but if you really need to there is a new pragma: PRAGMA UDF. With this pragma the statement is almost as fast as pure SQL.
A new step has been taken to continue on “least privileges”, meaning that the user only gets the privileges that are absolutely necessary. A Role can be granted to a PL/SQL unit.
- Improved programmer usability
The ability to inspecting the callstack has been improved by the introduction of a new package: UTL_CALL_STACK. The package contains numerous functions to help in this area, such as current_edition and lexical_depth.
White listing of program units: restrict which program unit can be called by other program units.
So, is PL/SQL still alive? YES! ALIVE AND KICKING!
- Oracle RDBMS 11gR2 – alter or replace user defined types even when there are dependencies
- SQL Script to empty out/cleanse a user schema
- Another VPD challenge with our Oracle Designer generated Web Forms application: No Data Found when synchronizing server derived values
- How to use an outerjoin to synchronise data
- Returning a Ref Cursor based on a PL/SQL Collection
- AMIS vat Oracle OpenWorld samen in speciale whitepaper
- OOW 2012: BPM is this year’s Fusion Middleware star
- OOW 2012: The yearly AMIS Review from Oracle Open World and JavaOne – slides available
- OOW 2012: Little things make me happy
- JavaOne 2012: Any news on the Java Caching Standard (JSR 107)?
- OOW 12: The Oracle Cloud strategy – explosive stuff or vaporware?
- JavaOne 2012: The Big Stories
- OOW 2012: Data Visualizations with ADF DVT – continuous evolution demonstrated
- JavaOne 2012: What’s new in Servlet3.1: An Overview
- OOW 2012 – The Big Stories