Store SQL*Plus variables The NEW_VALUE directive allows you to store data retrieved from an Oracle table as a variable inside the SQL*Plus script. Written by Donald Burleson, Contributor June 18 ...

Check the database you're currently in (the dropdown at the top of your SQL window). Likely you are in the wrong one from the home connection.