Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


Question:what is the new features in PL/SQL in 10g


  1. Regular expression functions REGEXP_LIKE , REGEXP_INSTR, REGEXP_REPLACE, and REGEXP_SUBSTR
  2. - Compile time warnings
  3. - Conditional compilation
  4. - Improvement to native compilation
  5. - BINARY_INTEGER made similar to PLS_INTEGER
  6. - INDICES OF , VALUES OF in FORALL lets you work on non-consecutive indices
  7. - Quoting mechanism . Instead of quoting single quotes twice everytime, give your own delimiter to go on using single quotes.
  8. Ex: q'!I'm a string, you're a string.!'
  9. - Flashback Query functions. SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN
  10. - Implicit conversion between CLOB and NCLOB
  11. - Improved Overloading
  12. - New datatypes BINARY_FLOAT, BINARY_DOUBLE
  13. - Global optimization enabled
  14. - PLS_INTEGER range increased to 32bit
  15. - DYNAMIC WRAP using DBMS_DDL

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes
28 views



Related Hot Questions



Government Jobs Opening


...