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

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

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

Though SQL (Structured Query Language) for databases has proved to be indispensable through decades of use, differences among SQL versions can challenge a software developer. For example, Microsoft's ...

Oracle's namesake database management system has a data type called a CLOB, or Character Large OBject. Though the standard character data type, called CHAR, has a size limit of 2,000 characters, you ...