SQL Server Management Studio (SSMS ... Perhaps a large block of variable declarations is at the top, and you need to keep referring to it in order to understand the code below.

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, 2002 at 6:01 p.m. PT ...