• 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

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

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

March 15, 2017 Uncategorized

12c Release 2, set feedback enhancement in SQL PLus

There’s a nice little touch to the “set feedback” command in SQL PLus in 12.2. There is a new “only”

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.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Version 7 was so much better...
  • The Fractional Part of a TIMESTAMP. Be careful.
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • A little known RI clause
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • MERGE and ORA-30926
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 810 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...