The ability to store SQL*Plus variables and fill them with Oracle data is a very powerful feature, and it makes SQL*Plus scripts more efficient because it reduces database access.

There are various ways of using global variables in Microsoft SQL Server 2000 DTS Designer tasks. This article, one in a series, looks into their role in exchanging data between packages, using ...