5 Replies Latest reply on Dec 6, 2012 9:06 AM by Girish Sharma

    Help me in creating script to check rows in a table


      I want to write a shell script which should run the sql statement (select count(*) from TRACKNTRACE.SSA_REPL_LOG;), and if the count(*) exceeds 600000, the error should be generated in alert log as : ORA-ERGO:“Golspie,Prodamp TRACKTRACE too high value, please stop the job, info on wiki”

      Is there any way to achieve it. I have read from some notes though not a good practice to use : dbms_system.ksdwrt(1,'test'), I am not sure how will I achieve my result?