 
      
    | You are here | martincarstenbach.com | ||
| | | | | parvu.org | |
| | | | | This article discusses implementing a database-level trigger to manage and restrict DDL operations by limiting access to specific users. Unauthorized users attempting DDL actions will encounter a custom error message. The trigger code is provided, along with examples of error stacks generated from prohibited actions such as adding a column or truncating a table. This... | |
| | | | | oralytics.com | |
| | | | | Oracle 12c was released just over a week ago and I've finally managed to get round to installing it.This must be the first time that I have done an install of an newly release Oracle Database, where everything worked first time. Typically I have learned from the past and have left it a few months... | |
| | | | | connor-mcdonald.com | |
| | | | | When I'm troubleshooting, a common workflow for me isextract a problematic SQL statement from V$SQL or V$SQLSTATS or an AWR report.drop the SQL text into SQL Developer or VS Code so that I can format it into a more readable format.That was starting to frustrate me so I thought: "Why not have a SQL Formatter... | |
| | | | | cardinalguzman.wordpress.com | |
| | | Encyclopedia Miscellaneous - 'quality' blogging since August 2011 | ||