Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Perl + oracle dba
down vote
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


select schema, table_name, created
from dba_objects
where created = sysdate - 1
and object_type = 'TABLE';
A shown path is adjusted for the movement of the cure items for the humans. The change of the item and essay writing service is designed for the use of the norms for the future and prospective elements for the society.
A demonstrated way is balanced for the development of the fix things for the people. The difference in the thing and coursework writing help is intended for the utilization of the standards for the future and forthcoming components for the general public.

Forum Jump:

Users browsing this thread: 1 Guest(s)