For each 12 hours i have to perform insert operation automatically how to write trigger for this .
Use DBMS_JOB. http://www.pinnaclepublishing.com/OP...2568F00065982B HTH
Sanjay G. Oracle Certified Professional 8i, 9i. "The degree of normality in a database is inversely proportional to that of its DBA"
Forum Rules