sqlplus – Learning is not a spectator sport

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

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

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

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

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

Excuse the hideous pun in the title. All will become clear shortly. Often we use SQL Plus to run scripts

This “problem” rates in the top 10 all time viewed questions on AskTom, and it demonstrates the importance of reading

SQL Plus does not appear to be bothered by the direction of slashes, ie “/” or “\” in its scripts

I just posted a video on how I get the most out of my SQL*Plus usage. You can check it

I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a