Database Administration (MOSC)

MOSC Banner

How to Email "select statement"

edited Apr 2, 2010 7:21PM in Database Administration (MOSC) 3 commentsAnswered
 Dear community
I would like to get an email of the following select statement:

Select db_name, db_key, newest_backup_time, oldest_backup_time, Cast(Output_bytes/1024/1024/1024 as number(8,1)) as GByte_AllSets
    from bakrman.rc_backup_set_summary
    order by newest_backup_time ASC


How could I create a scheduled oracle task which emails me the select statement every day?

Thank you in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center