8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Conditional Compilation in Oracle 10g Database Release 2

Catalina said...

$IF DBMS_DB_VERSION.VER_LE_10_1 $THEN...this won't compile on version < 10, so I guess this example don't make much sense..altought article is useful

Tim... said...


Conditional compilation was only introduced in 10g, so the whole thing will fail to compile in 9i.

The point is, if the version is 10gR1 you do one thing, if it's 10gR2 you do another. This code is not catering for pre-10g.



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.