MyEducationPath  

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Perl + oracle dba
#1
0
down vote
favorite
I'm newbie in perl and trying to list out all oracle schema tables which were created yesterday i.e. (sysdate - 1)

trying to achieve above via perl script and run against oracle database.

Q: 1. List all recently created oracle table using perl script 2. columns in result (Schema, table_name, created datetime) 3. Only provide output if any new table was created orelse no email via scheduler

e.g.

select schema, table_name, created
from dba_objects
where created = sysdate - 1
and object_type = 'TABLE';
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)