1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need help on sql

Discussion in 'SQL PL/SQL' started by jhonnyrip, May 12, 2018.

  1. jhonnyrip

    jhonnyrip Active Member

    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    lansing
    I have cron to run every one hr., need to send email only new errors from table.

    Here is the my query

    select test_id
    from test
    where run >= trunc(current_timestamp) - TO_DSINTERVAL('0 01:00:00')
     
  2. jhonnyrip

    jhonnyrip Active Member

    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    lansing
    Just FYI : The following query worked

    select test_id
    from test
    and run between sysdate -TO_DSINTERVAL('0 01:00:00') and sysdate
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    771
    Likes Received:
    145
    Trophy Points:
    830
    Location:
    Russian Federation
    For a start:
    1) change notification or dbms_scheduler
    2) utl_mail

    List the examples