Mastering the Oracle Stack, One Post at a Time.
Practical scripts & utilities
Automation, security scripts, tools, utilities
The PL/SQL reference guide has a short section and example for the INSTEAD OF CREATE ON SCHEMA trigger. Since the description was so little and could not find much detail on the internet, tried some examples as below. This feature is good to prevent any CREATE operation for an user, giving him/her privilege to alter or drop … Read more
Few quick screens to show the download and install of SQL Developer 4.0 on Oracle Linux 6.3. SQL Developer 4.0 is cool… for DBA and Developer… You can pretty much do almost all day-to-day database administration tasks using SQL Developer… Read my doc on Slideshare… More… Follow Jeff’s blog… And check out OBE… … Read more