CODEWITHSUNDEEP
sqloracle-databaseplsql
starko
starko

Reputation: 1149

listening for changes in the table on Oracle PL/SQL

Is there such a thing as listening in the Oracle database from SQL or PL / SQL level?

I would like to change the data in a table, but I only need it if I update in a different table.


Step by step:
1. Change in table A
2. I check if the correct status is in table B
3. If it is not there, I am waiting for a change in status(this is my problem - how to wait?). Until the status changes (controlled by JOB), I can do nothing
4. The status in table B is changing, it takes the next action

It is possible by using another application, eg in Java or C#. However, I would like to ask about such possibilities without an additional programming language.

I am asking for advice.

Upvotes: 1

Views: 740

Answers (1)

Vinish Kapoor
Vinish Kapoor

Reputation: 679

Write the trigger on B table on update of column status and whenever the update will happen in B table you can write the code in trigger to update data in A table.

Upvotes: 1

Related Questions