Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
declare crlf varchar2(2):= CHR( 13 ) || CHR( 10 ); message_v varchar2(32000); vJobNumber binary_integer; begin dbms_job.submit( job => vJobNumber, next_date => to_date('14:00','HH24:MI') interval => (trunc(sysdate) +30/1440),what =>' for i in (select user_id, account_status, lock_date from dba_users where username = 'AGENT_USER' and account_status = 'LOCKED') loop message_v := message_v || i.user_id || ' is in ' || i.account_status || ' status since ' || to_char(i.lock_date,'MM/DD/YYYY') || crlf; end loop; utl_mail.send ( sender => 'firstname.lastname@example.org', recipients => 'email@example.com', subject => 'AGENT_USER Account is LOCKED', message => message_v ); end; /
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|any step by steps guide on how to install Oracle 12c on Windows 10||8||110|
|sum of columns in a row in oracle||3||44|
|oracle numeric condition check||4||37|
|oracle spooling query into csv eliminating new line character||9||40|