SQL and PL/SQL are the languages mastered by every Oracle developer. But the world doesn’t stand still. After the initial training, most developers dive right in and use the acquired knowledge more effortlessly over the years. Best practices are also developed. However, not everyone has the opportunity to explore other aspects of these languages or
SQL and PL/SQL are the languages mastered by every Oracle developer. But the world doesn’t stand still. After the initial training, most developers dive right in and use the acquired knowledge more effortlessly over the years. Best practices are also developed. However, not everyone has the opportunity to explore other aspects of these languages or
Oracle DBAs love to use SQL*Plus when installing database objects. As a developer, I make SQL install scripts. Which then are executed by these DBAs. These scripts contain references to other files with the actual SQL statements. Below is an example of an install script, here the user will be prompted with the step and
