sql query

[Melton Low]

That is not a query for data.  It's a trigger that runs after you delete a
row from the t_custlevel table.  I suspect you need to know more than just
trying to execute this.  Suggests you start with the Oracle documentation at
the oracle site.

You should also ask at the oracle site.

Cheers, Mel

On Mon, Jan 24, 2011 at 8:06 AM, Kaushal Shriyan
<kaushalshriyan at gmail.com>wrote:

> 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
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20110124/b5500866/attachment.html>