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

Although there are many tools available that are far more user-friendly than SQL*Plus for manipulating and accessing Oracle database data, I still find myself occasionally using SQL*Plus when I need ...

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

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