Hi<br><br>How do i run the below query inside sql > prompt in Oracle 11g R2 SE on Ubuntu Linux 10.04<br><br>"CREATE TRIGGER "ICD".TR_DEL_SYSTEMALERTCFG_CSTLVL"<br> " after delete on t_custlevel"<br>
"begin"<br> " delete t_monitor_systemalertcfg a"<br> " where a.queuetype = 4"<br> " and a.queueid not in ("<br> " select <a href="http://b.id">b.id</a> from t_custlevel b"<br>
" where a.subccno = b.subccno"<br> " and a.vdn = b.vdn"<br> " );"<br> "end TR_DEL_SYSTEMALERTCFG_CSTLVL;"<br> ""<br>
""<br>
<br>Please suggest.<br><br>Thanks<br><br>Kaushal<br>