Re: How do I detect inserted record or updated record dynamic in oracle?

Petit Donghwa schrieb:
> hi
>
> I need some helps to find solution for
> detecting inserted or updated record in the table.
>
> If I have to use trigger, how can I use it?
>
> For example, I connect DB(oracle) and one Web page in php.
> In this php page, it must check one table
> if it is changed or not.
> if it is changed I must detect dymanically and automatically reflect
> and show the changed record on the web page.
>

Add a field is_new to the table with default value 1. In your PHP, do a SELECT FOR UPDATE ... where is_new = 1 , show the records to the user and then, within the same PHP script, update all records setting is_new = 0;
> Can you have some idea to solve this problem?
> with java applet, is it possible too??
>

Java applets are client side, so you have to connect the client to your database directly? Security will be an issue, e.g. Oracle's listener's port (1521) should be open etc.

There are other reasons why not to use applets, e.g. not all browsers support Java, downloading an applet needs bandwith etc. IMHO, server side scripting is the better way!

Regards!
Rainer
> thanks
>
> donghwa

-- 
------------------------------------------------
Rainer Herbst         Linux - Registered
ZEIK                  User #319157
Universität Potsdam   Usual disclaimers applies!
------------------------------------------------