Oracle‘s SQL*Plus is not as user-friendly as SQL Developer or JDeveloper for manipulating data in an Oracle database, but it is still commonly used.In fact, SQL*Plus is often preferred to the ...

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

Previously, the glogin.sql and login.sql files were executed only once during login to SQL*Plus. In Oracle 10g, the glogin.sql and login.sql are run whenever you connect to a new user.

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