Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

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 rifling through the Monastery: (6)
As of 2018-06-18 15:58 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (110 votes). Check out past polls.