Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: List DB tables

by nikosv (Hermit)
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


Comment on Re: List DB tables
Re^2: List DB tables
by homer4all (Initiate) 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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1022292]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (12)
As of 2014-07-14 12:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (259 votes), past polls