Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

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]
[Lady_Aleena]: Lax, that would take it down to a little less than 100 characters. The module name is nearly 80 characters long.
Lady_Aleena has fumble fingers today.
[Lady_Aleena]: Sorry for the name typo LanX.
[LanX]: never lad_ena!
[LanX]: ;)
[Lady_Aleena]: IMO, Fancy::Join:: Grammatical isn't bad, but RolePlaying:: WorldBuilding:: WorldBuildersGuide book::ClimateTerra inSubsistance is on the long side.
[Lady_Aleena]: I'm still in reorganizing/ renaming mode.

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (8)
As of 2017-05-24 21:59 GMT
Find Nodes?
    Voting Booth?