Oracle SQL*Plus has a very useful subparameter to the column parameter called NEW_VALUE. ... Now that we understand how SQL*Plus variables are stored, let's examine a real-world example.