6 Replies Latest reply: Jul 10, 2014 4:49 PM by Zlatko Sirotic RSS

    Need to update coulm after 30 sec in to table after login user.

    Vedant

      Dear All,

       

      i need to update status in a table after 30 sec when user login so i have code

       

      DECLARE

         v_login_in   NUMBER:=0;

         v_sec        NUMBER:=0;

      BEGIN

         SELECT   to_number(TO_CHAR (LAST_LOGON_DATE, 'SS'))

           INTO   v_login_in

           FROM   user_mas

          WHERE   user_id = :app_user;

         SELECT   to_number(TO_CHAR (SYSDATE, 'SS') + 10)

           INTO   v_sec

           FROM   DUAL;

         IF v_login_in > v_sec  THEN

        

         UPDATE USER_MASTER SET NOTIFICATION_DISPLAY='Y' WHERE USER_ID='00002';

          

         END IF;

      END;

       

       

      What should i pass if condion to update user_master table.