Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Printing a spool under SQL*Plus

Re: Printing a spool under SQL*Plus

From: thoidi8 <xiongh_at_hotmail.com>
Date: 1997/12/10
Message-ID: <Pine.A41.3.95.971210173604.40554A-100000@f1n11.spenet.wfu.edu>#1/1 







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 Wed Dec 10 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US