Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: List DB tables

by nikosv (Chaplain)
on Mar 07, 2013 at 19:07 UTC ( #1022292=note: print w/replies, xml ) Need Help??

in reply to List DB tables

I am not familiar with Oracle,but is it possible to add a trigger on the system/catalog table that gets fired when an INSERT happens?

Upon the table's creation, an entry of that table will be inserted into the catalog and subsequently the trigger will fire and raise a database event which would notify any registered event listeners to perform an action. In this case the listener would be your script,and the action would be to send an email

But I don't know if Oracle supports external database events like Ingres does for example Raise a Database Event

Replies are listed 'Best First'.
Re^2: List DB tables
by homer4all (Acolyte) on Mar 07, 2013 at 19:11 UTC

    thanks niko...

    I am really new to perl and currently just trying to run simple sql query on oracle db to identify what all tables created 'sysdate-1' and email only if logfile has any output from query.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1022292]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2017-12-16 09:29 GMT
Find Nodes?
    Voting Booth?
    What programming language do you hate the most?

    Results (449 votes). Check out past polls.