• 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: sqlcl

March 7, 2023 Uncategorized

Avoiding INSERT glitches with SQL*Plus and SQLcl

Sometimes in data centric applications, we want to store metadata (such as HTML or CSS or other such text) in

Continue reading

November 2, 2021 Uncategorized

Quick and easy sample data

If you head over to the official database sample schema github repo you’ll find all the standard schemas that you’ll

Continue reading

October 29, 2021 Uncategorized

Keeping my SQLcl toasty fresh!

With the recent change to the licensing rules for SQLcl, a simple “yum” command on your Linux box gets you

Continue reading

October 7, 2021 Uncategorized

The HOST command in SQL*Plus and SQLcl

Truth be told, the original title of this post was going to be “How I lost an entire day debugging

Continue reading

September 24, 2021 Uncategorized

EZconnect for SQL*Plus

Just a quick tip to solve a common issue that is catching people out. The EZconnect syntax is a great

Continue reading

August 5, 2019 Uncategorized

Take a COPY out of SQLcl’s book

As the world continues to get smaller, it makes sense for all databases to be defined to handle more than

Continue reading

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to TREAT data in a CLOB as JSON
    • Extended VARCHAR2 and the hidden LOB
    • How to generate random unique values
    • Modifying tables without losing materialized views
    • No more stale statistics in 19c
    • Free In-memory in Oracle Database 19c
    • Generating INSERT scripts that run fast!
    • 19c Express Edition #JoelKallmanDay
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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