Every Oracle PL/SQL developer concerned about the performance impact of repeated if... then... else calls can use conditional compilation to scrub these calls from production code. And that's just the beginning.
Although not as full-featured as some commercial tools, version 1.0 of SQL Developer, Oracle's free PL/SQL development IDE, is complete enough to use as the development platform for a complex PL/SQL project.
Oracle 9i introduced data types and support to handle time zones. Use these data types to make your Oracle code time zone aware.
How can you keep slow extract, transform, and load operations from bogging down your production instance? Oracle 10g's Data Pump API offers a great solution.
Oracle provides developers a simple API that enables them to interact with most Microsoft COM objects directly from PL/SQL. Learn how to install the COM option and tap into the functionality of pre-built COM components on your machine right now.
Author Bio
