Re: Printing a spool under SQL*Plus

Hello thoidi8,
try this:

insert into test_table
values ('XXX','1','2','3')
/
spool filename.lis
select * from test_table
/
spool off

Corinna Becker

thoidi8 <xiongh_at_hotmail.com> wrote in article <Pine.A41.3.95.971210173604.40554A-100000_at_f1n11.spenet.wfu.edu>...
> Hi there...
>
> Could anyone helps me please....
>
> I have a select statement
> SELECT my_field from MY_TABLE;
>
> Here is my problem;
> After the MY_TABLE got updated, then spool this select statement.. For
> example;
> SPOOL /export/home/my_dir/my_dat/my_field.dat
> SELECT my_field FROM MY_TABLE;
> SPOOL OFF;
>
> I have tried with create trigger but it didn't work??? Any comment is
> welcome.... TIA
>
> e-mail: thoidi8_at_hotmail.com
>
>
> HAVE A NICE DAY. BYE ...
>
>
>
Received on Tue Dec 16 1997 - 00:00:00 CST