Younger DBAs, or those that started on Windows, may rely on GUI tools like Enterprise Manager and SQL Developer.  However, this old DBA is entrenched in the command line world.  GUI tools have their uses, but using a suite of scripts designed for SQL*Plus is the most flexible and portable practice.  Independence from tools that are not universally installed is especially useful for contractors, consultants or anyone that wants to change organisations during his/her career.

The Windows GUI version of SQL*Plus disappeared with 11g, but we still have the command line (DOS) version available.  Until SQLCL is ready for me (and me for SQLCL), I’ll be using SQL*Plus.  See the first of my Oracle on Windows tips: SQL*Plus on Windows (Updated Jan 2018).




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s