techtip – Page 4 – Learning is not a spectator sport

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

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