• About
  • All Posts
  • 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

Tag: 19c

February 3, 2021 Uncategorized

Blockchain tables are here in 19c!

Slow down there….Take a breath. Because if you’ve read the title of this post and you’re already logging on to

Continue reading

January 4, 2021 Uncategorized

"Big Mac and Size"..Handling large SQL Macros

Happy 2021 everyone! And what better way to start than a cheesy pun to make you groan and already to

Continue reading

November 24, 2020 Uncategorized

The power of SQL macros

Here is another example of what I’m sure will just become a plethora of such examples from the community on

Continue reading

November 13, 2020 Uncategorized

SQL Macros = SQL Injection ?

In my recent post about SQL Macros and their availability in 19c, I had some comments about parameter passing, these

Continue reading

November 10, 2020 Uncategorized

Faster software installations

Just a quick tip today thanks to the one of the readers on my blog. If you’re installing Oracle 12c

Continue reading

October 2, 2020 Uncategorized

Compression default settings

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

Continue reading

stack of macro vitamins
September 14, 2020 Uncategorized

When can I use SQL Macros?

One of the very cool features we’ve been talking about for 20c is SQL Macros. But you no longer need

Continue reading

ace revealed by magician
September 7, 2020 Uncategorized

Docs hack to save you time!

The tech world is a big and varied place, so whilst there are some database customers running on 19c and

Continue reading

19c scheduler and jobs
September 3, 2020 Uncategorized

DBMS_JOB and 19c – code changes needed

Here’s a “gotcha” brought to my attention by one of our AskTOM readers. I’ve mentioned in the past that DBMS_JOB,

Continue reading

August 17, 2020 Uncategorized

Faster DISTINCT operations in 19c

If I gave you a telephone book and asked you to tell me how many distinct street names are present

Continue reading

Posts navigation

1 2 3 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
  • Why you keep getting "ORA-01653: unable to extend table"
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • LOBs from afar
  • My APEX was fine and then it wasn't
  • Updating indexes with partition maintenance
  • Pluggable database and restricted sessions
  • NULL's vs NOT NULL's and Performance
  • Generating INSERT scripts that run fast!
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×