I have a test table “bbb”.
COLB |
---|
bba |
aa1 |
bbb |
aaa |
bbb |
bb1 |
and do following commands:
variable a varchar2(20);
begin
:a:='bbb';
end;
/
set heading off;
spool C:Temptest.txt;
set feedback off;
select * from bbb t where t.colb=:a;
spool off;
But I see in test.txt following:
bbb
bbb
a
---------
bbb
How can I rid of information?:
a
---------
bbb
I need only info of result in file:
bbb
bbb
I tried to execute.
SET VERIFY OFF:
SET ECHO OFF;
But it does not help me.
New contributor
Timur Pak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3