SQL*Plus has never been known for its ease of use, but its appeal does seem to grow as one uses it regularly. One recent piece of evidence regarding the continued use of SQL*Plus is the recent blog ...

The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility program, and some to support the new features. Here's a rundown of the new features in Oracle ...

So because god hates me, I have to work with Oracle. Which means I need to re-learn SQL Plus. I knew how to get around it back in the day, but since then I have used modern RDBMS's and have become ...

Many books, blogs, and articles on using Groovy with Windows rightly point out that some of the commonly used commands in Windows are not actually executables, but are instead built-in commands. These ...

Oracle SQL*Plus has a very useful subparameter to the column parameter called NEW_VALUE. The NEW_VALUE directive allows you to store data retrieved from an Oracle table as a variable inside the ...

I am trying to output several large tables (10's of MB) from SQL PLus over Citrix and it's really slow. Code: set pagesize 0 set autotrace off set flush off set termout off spool l:\spool\acctact.txt ...