Hi Friends,

Was there any answer for getting the output continouslly without manual interferance:


eg . FOR SCOTT

SELECT * FROM dept;

DEPTNO DNAME LOC
------- -------------- ------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL> SELECT * FROM dept1;

DEPTNO DNAME
---------- --------------
10 ACCOUNTING
20 RESEARCH
30 SALES
40 OPERATIONS

Is there any STORED PROCEDURE available .


Thanks in Advance

gandhi