Re: Another Trigger Query...

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 15 Dec 2004 08:07:28 +0100
Message-ID: <41bfe296$0$11560$626a14ce@news.free.fr>

<arijitchatterjee123_at_yahoo.co.in> a écrit dans le message de news:1103082634.656686.281310_at_f14g2000cwb.googlegroups.com...
> Dear Faculties,
> I have another basic question.I have two tables TAB1 and TAB1COPY
> whenever I am doing any update or insert or delete on TAB1 that
> automatically updating TAB1COPY.But I want to restrict direct
> modification in TAB1COPY through SQL+ screen also.How I should
> proceed?Please give me some clue.
> Thanks in advance.
> Regards
> Arijit Chatterjee
>

You can find the module name ("SQL*Plus") in v$session.module.

Regards
Michel Cadot Received on Wed Dec 15 2004 - 01:07:28 CST