sql query

[Kaushal Shriyan]

Hi

How do i run the below query inside sql > prompt in Oracle 11g R2 SE on
Ubuntu Linux 10.04

"CREATE TRIGGER "ICD".TR_DEL_SYSTEMALERTCFG_CSTLVL"
 "  after delete on t_custlevel"
 "begin"
 "  delete t_monitor_systemalertcfg a"
 "  where a.queuetype = 4"
 "    and a.queueid not in ("
 "                  select b.id from t_custlevel b"
 "                  where a.subccno = b.subccno"
 "                    and a.vdn = b.vdn"
 "                  );"
 "end TR_DEL_SYSTEMALERTCFG_CSTLVL;"
 ""
 ""

Please suggest.

Thanks

Kaushal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110124/ff68725e/attachment.html>