• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: techtip

April 17, 2016 Uncategorized

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

Continue reading

April 13, 2016 Uncategorized

Active and Inactive Sessions

Most people are aware of the STATUS column in V$SESSION. If it’s ‘ACTIVE’ then that connection is in the process

Continue reading

March 31, 2016 Uncategorized

Dealing with URL’s

If you are creating or handling URL’s, there is a nice little package routine that assists with handling all those

Continue reading

March 31, 2016 Uncategorized

Opatch quick tip

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

Continue reading

March 29, 2016 Uncategorized

Median in SQL

Are you stuck with a database that does not offer analytic SQL facilities ? Never mind, you can use the

Continue reading

March 16, 2016 Uncategorized

Database dictionary corruption ? Maybe not.

At first glance, this looks like a major drama. Some sort of database dictionary corruption, or internal error. But we’ll

Continue reading

February 29, 2016 Uncategorized

Amped on Amper

This “problem” rates in the top 10 all time viewed questions on AskTom, and it demonstrates the importance of reading

Continue reading

February 16, 2016 Uncategorized

Never rely on an assumed order

We’ve (hopefully) all had it drummed into us enough times – you cannot assume the order of results from queries

Continue reading

January 27, 2016 Uncategorized

SQL*Plus quick tip

SQL Plus does not appear to be bothered by the direction of slashes, ie “/” or “\” in its scripts

Continue reading

January 20, 2016 Uncategorized

Problematic SQL ? PL/SQL is your friend.

So then… I’ve written a crappy piece of SQL. It wouldn’t be the first time I’ve done it… and it

Continue reading

Posts navigation

«Previous Posts 1 2 3 4 5 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Is my table marked for archive?
  • Why you keep getting "ORA-01653: unable to extend table"
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • How to generate random unique values
  • Don't run tight on PGA
  • Pluggable database and restricted sessions
  • DBMS_JOB - the joy of transactions
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 811 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...