Quick tip on Function Based Indexes
For “normal” indexes, USER_IND_COLUMNS will contain the column name(s) for an index, but things (appear to) go astray when looking
For “normal” indexes, USER_IND_COLUMNS will contain the column name(s) for an index, but things (appear to) go astray when looking
Most people are aware of the STATUS column in V$SESSION. If it’s ‘ACTIVE’ then that connection is in the process
If you are creating or handling URL’s, there is a nice little package routine that assists with handling all those
I was patching my 12.1.0.2 home installation to the latest patchset today, and got the following error: C:\oracle\stage\22581007>opatch apply Oracle
Are you stuck with a database that does not offer analytic SQL facilities ? Never mind, you can use the
At first glance, this looks like a major drama. Some sort of database dictionary corruption, or internal error. But we’ll
This “problem” rates in the top 10 all time viewed questions on AskTom, and it demonstrates the importance of reading
We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries
SQL Plus does not appear to be bothered by the direction of slashes, ie “/” or “\” in its scripts
So then… I’ve written a crappy piece of SQL. It wouldn’t be the first time I’ve done it… and it