"SELECT" output into a variable.

People,

        Does any one knows how can I set the value of a variable from the output of a SELECT statment in SQLPLUS?

        What I need is some thing like this:

define VARIABLE=(select SUM(width) from col where tname = 'TABLE_NAME') set line &VARIABLE

        Thanks. Received on Thu Mar 26 1998 - 00:00:00 CST