SPOOL, TITLE, BREAK, HEADING

set heading off;
DEFINE a=200
select name from emp where name=&a;

if u give &&a then a value is stored in memory, until u undefine
select name from emp where name=&&a;
UNDEFINE a;

> TITLE OFF
> BTITILE OFF

> BREAK ON dcode
> CLEAR BREAK

> create table test(code number,name char(10),age number);
> insert into table values(&code,'&name',&age);
>/ //this slash will help you to enter next set of values

/* to save output - means save in file. .lst is the extension for test1 file. */
> SPOOL c:\test1
do something, then
> SPOOL OFF