By using the NEW_VALUE parameter, you can make your SQL*Plus script behave like a real programming ... how SQL*Plus variables are stored, let's examine a real-world example. Here's an example ...