Thursday 29 December 2011

PL/SQL New Features and Enhancements in Oracle Database 11g Release 1


PL/SQL New Features and Enhancements in Oracle Database 11g Release 1

  1. Enhancements to Regular Expression Built-in SQL Functions
  2. SIMPLE_INTEGER Datatype
  3. CONTINUE Statement
  4. Sequences in PL/SQL Expressions
  5. Dynamic SQL Enhancements
  6. Generalized Invocation
  7. Named and Mixed Notation in PL/SQL Subprogram Invocations
  8. Automatic Subprogram Inlining
  9. PL/Scope
  10. PL/SQL Native Compiler Generates Native Code Directly
  11. New PL/SQL Compiler Warning
  12. PLS-00436 Restriction in FORALL Statements Removed
  13. Topics covered in separate articles on this site:
  14. Cross-Session PL/SQL Function Result Cache
  15. Trigger Enhancements in Oracle Database 11g Release 1
  16. PL/SQL Hierarchical Profiler
  17. Native Oracle XML DB Web Services
  18. Database Resident Connection Pool
Posted by at

2 comments:

  1. Unknown3 May 2018 at 22:08

    Hey,


    I learnt so much in such little time about ORACLE APPS TECHNICAL. Even a toddler could become smart reading of your amazing articles.
    I have requirement like

    both tables have 50+ millions record so I want to automate a job which will execute this query for 1millions records for one time and then again 1 millions for second time...like loop and store output in record type.

    But nice Article Mate! Great Information! Keep up the good work!

    Kind Regards,
    Vineeth

    ReplyDelete
  2. Unknown20 June 2018 at 21:49

    Olà,


    Grazie! Grazie! Grazie! Your blog is indeed quite interesting around #topic! I agree with you on lot of points!

    how to get the first non space character from a string in Oracle. Could you help me on this?

    Anyways great write up, your efforts are much appreciated.


    Many Thanks,
    Radhey

    ReplyDelete

Subscribe to: Post Comments (Atom)