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

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

February 6, 2023 Uncategorized

When EZCONNECT is not so easy

Pop over to AskTom and you’ll see two entries that commonly pop up on our top 20 most viewed questions

Continue reading

January 17, 2022 Uncategorized

Careful with SQL*Plus and SQL_ID feedback

Just a quick word of warning on a cool feature of SQL*Plus that came along from 18c onwards. I’ve posted

Continue reading

a picture from the rear of a mclaren sports car
December 6, 2021 Uncategorized

SQL*Plus shortcut for fast data unload

I published a video a few days ago on the various tools you can use to unload data out of

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 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

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

April 24, 2020 Uncategorized

SQL Plus and the ROWPREFETCH parameter

Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to

Continue reading

January 31, 2020 Uncategorized

New LINESIZE settings for SQLPlus

Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with

Continue reading

Posts navigation

1 2 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.

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
    • No more stale statistics in 19c
    • Modifying tables without losing materialized views
    • Free In-memory in Oracle Database 19c
    • 19c Express Edition #JoelKallmanDay
    • Generating INSERT scripts that run fast!
    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
     

    Loading Comments...