Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

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

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

When I am working with an Oracle database, I still find myself using SQL*Plus for many quick and dirty database queries. In particular, I often look up constraints in SQL*Plus. In this post, I look at ...

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