NineNiftyNuances

NineNiftyNuances - 07/15/11 NINE NEW and NIFTY NUANCES OF...

Info iconThis preview shows pages 1–8. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 07/15/11 NINE NEW and NIFTY NUANCES OF ORACLE 9 i Steven Feuerstein [email protected] www.quest.com 07/15/11 SOFTWARE USED IN TRAINING Presentations and demonstration scripts for this presentation can be found on the PL/SQL Pipeline: – www.quest-pipelines.com – Quest Experts page for the presentations – Oracle PL/SQL archives, miscellaneous, PL/SQL seminar files, and download demo.zip and review filedesc.doc for a description of many of the files filename.sql 07/15/11 THE NINE NIFTIEST NUANCES Nifty 1. Inheritance in object types Nifty 2. Pipelined, parallel-executed table functions Nifty 3. TIMESTAMP and INTERVAL Nifty 4. New operators: CASE, NVL2, COALESCE Nifty 5. Multi-level Collections Nifty 6. Associative Tables (Oracle9i Release 2) Nifty 7. Record-based DML (Oracle9i Release 2) Nifty 8. The new and improved UTL_FILE (Oracle9i Release 2) Nifty 9. The XMLType datatype 07/15/11 INTEGRATED SQL AND PL/SQL PARSERS From now on, PL/SQL immediately supports all SQL syntax changes to embedded SQL – Anything you can do in SQL directly, you will be able to do in PL/SQL The switch to a single parser (and more consistent error checking) means, however, that some of your previously "valid" code might not compile 07/15/11 PL/SQL9i STRICTNESS CAN HURT! Pre-9i, PL/SQL permitted some abnormal behaviors that are no longer allowed by Oracle9i, including: – Make forward references to RECORD and TABLE types when declaring variables – Specify the name of a variable (not a datatype) in the RETURN clause of a function spec – Assign values to the elements of an index-by table IN parameter – Pass the fields of a record IN parameter to another subprogram as OUT parameters – Use the fields of a record OUT parameter on the right-hand side of an assignment statement – Use OUT parameters in the FROM list of a SELECT statement 07/15/11 HOW TO ENSURE BACKWARD COMPATIBILITY For backward compatibility, you might want to keep this particular Version 2 behavior – You can do that by setting the PLSQL_V2_COMPATIBILITY flag – On the server side, you can set the flag in two ways: • Add the following line to the Oracle initialization file: • PLSQL_V2_COMPATIBILITY=TRUE Execute one of the following SQL statements: – ALTER SESSION SET PLSQL_V2_COMPATIBILITY = TRUE; – ALTER SYSTEM SET PLSQL_V2_COMPATIBILITY = TRUE; 07/15/11 ORACLE OBJECT TYPES Which best describes your relationship with Oracle's Object Types?...
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 / 62

NineNiftyNuances - 07/15/11 NINE NEW and NIFTY NUANCES OF...

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

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