|
You are here |
martincarstenbach.com | ||
| | | | |
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... | |
| | | | |
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... | |
| | | | |
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... | |
| | | | |
yieldcode.blog
|
|
| | | Take a good look at the following function and try to understand what it's doing. function do_magic(a, b) { return a + b; } | ||