Sayantan's blogs on Oracle

Learn Oracle with Sayantan

Home
Blogs
About
Privacy Policy
Contact Us

PLSQL_COMPILER

CONDITIONAL COMPILATION

ADVANCED PLSQL, PLSQL_COMPILER / By sayan_bappa@yahoo.co.in / 29/06/2023 29/06/2023 / Leave a Comment

CONDITIONAL COMPILATION

Oracle 10g release 2 introduces a new feature called Conditional compilation. It allows PLSQL compiler to compile a selected parts of a program based on conditions you specify with the $IF directive in PLSQL.

It enables you to …

PLSQL COMPILER

PLSQL, PLSQL_COMPILER / By sayan_bappa@yahoo.co.in / 19/06/2023 19/06/2023 / Leave a Comment

PLSQL COMPILER

Before oracle 11g, the PLSQL Compiler translated our source code to system code without applying many changes to improve the performance. But now Oracle PLSQL uses a new optimizing compiler that can rearrange our code for better performance.…

Search for: