Learning is not a spectator sport

12c FETCH FIRST

Tom Kyte’s latest magazine article talks about the new FETCH FIRST syntax in 12c. You can read about that at:

Just a quick note to let you know I’ll upload the slides in the next few days

Sometimes even Oracle itself just can’t cope with the 30 character limit This from a M000 trace file 🙂 ***

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then

You’ve got a big table…you want to add an index. Will you have enough space ? Well, its not perfect

As several bloggers have already pointed out, column order changes when you start playing with invisible columns, for example SQL>

In new releases, its often the little things that really catch my attention. Like this one…. I love it SQL>

This is not a complete how-to, because I do not think its warranted…you pretty much click Next Next Next (which

A friend was recently describing Agile to me…I stress, not Agile the principle, but Agile the way its been implemented

Its been well documented for a while that Oracle were not going to allow raw devices in 12….but this still