PLSQL_9i_New_Features_Ppt

PLSQL_9i_New_Features_Ppt - Bryn Llewellyn Product Manager...

Info iconThis preview shows pages 1–18. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Bryn Llewellyn Product Manager for PL/SQL Oracle Corporation PL/SQL enhancements in Oracle9 i paper #129, Oracle OpenWorld, San Francisco, Tue 4-Dec-2001 But before I start… But before I start… OTN homepage OTN homepage Technologies Technologies PL/SQL PL/SQL otn.oracle.com/tech/pl_sql otn.oracle.com/tech/pl_sql What are the Benefits? y Speed and scalability y Functionality y Usability for the developer What’s been enhanced? y Implementation y Language features y Supplied packages What kind of enhancements? y Transparent y Semi-transparent y New features – New constructs in the language – Richer APIs in the supplied packages Here comes the list… Here comes the list… Implementation Feature Perf Funct Use Feature Feature Perf Perf Funct Funct Use Use Native compilation of PL/SQL 3 Native compilation of PL/SQL Native compilation of PL/SQL 3 Manipulating records faster by up to 5x 3 Manipulating records faster by up to 5x Manipulating records faster by up to 5x 3 Inter-package calls faster by up to 1.5x 3 Inter Inter-package calls faster by up to 1.5x package calls faster by up to 1.5x 3 Utl_Tcp native implementation 3 Utl_Tcp Utl_Tcp native implementation native implementation 3 Common SQL parser 3 3 Common SQL parser Common SQL parser 3 3 Language features Feature Perf Funct Use Feature Feature Perf Perf Funct Funct Use Use Table functions 3 3 3 Table functions Table functions 3 3 3 Cursor expressions 3 3 3 Cursor expressions Cursor expressions 3 3 3 Multilevel collections 3 3 3 Multilevel collections Multilevel collections 3 3 3 Bulk binding in native dynamic SQL 3 3 Bulk binding in native dynamic SQL Bulk binding in native dynamic SQL 3 3 Exception handling in bulk binding DML operations 3 3 Exception handling in bulk Exception handling in bulk binding binding DML operations DML operations 3 3 CASE statements and CASE expressions 3 CASE statements and CASE expressions CASE statements and CASE expressions 3 Exception handling in bulk DML y Consider giving employees a 10% raise where employee_id among the values in a table of numbers… y forall j in id.first..id.last y There might be a per department salary cap – so some intended updates will fail y Pre-Oracle9 i the whole bulk statement failed y Now the OK updates will fail and the exceptions can be reported y save exceptions sql%bulk_exceptions collection Multilevel collection syntax for j in my_multi.first..my_multi.last loop for k in my_multi(j).first..my_multi(j).last loop Show ( my_multi(j)(k) ); end loop; end loop; y Collections can be nested to arbitrary depth CASE statement syntax case n when 1 then Action1; when 2 then Action2; when 3 then Action3; else ActionOther; end case; CASE statement syntax case when p = 1 then Action1; when q = 1 then Action2; when r > 1 then Action3; else ActionOther; end case; y “searched” variety CASE expression syntax text := case n when 1 then 'one' when 2 then 'two' when 3 then 'three' else 'other' end; CASE expression syntax text := case...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 95

PLSQL_9i_New_Features_Ppt - Bryn Llewellyn Product Manager...

This preview shows document pages 1 - 18. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online