No details Oracle cursor -- time function instance: selectsysdate, add_months (sysdate, 12) fromdual; -- add 1 year selectsysdate, add_months (sysdate, 1) fromdual; -- add January selectsysdate, to_char (sysdate + 7, yyyy-mm-ddHH24: MI: SS) fromdual; -- add 1 week selectsysda
No details Oracle cursor -- time function instance: select sysdate, add_months (sysdate, 12) from dual; -- add 1 year select sysdate, add_months (sysdate, 1) from dual; -- add select sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add select sysda for 1 week
<无详细内容> Oracle cursor
-- Time function instance: select sysdate, add_months (sysdate, 12) from dual; -- add 1 year select sysdate, add_months (sysdate, 1) from dual; -- add January select sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 week select sysdate, to_char (sysdate + 1, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1-day select sysdate, to_char (sysdate + 1/24, 'yyyy-mm-dd HH24: MI: SS ') from dual; -- add 1 hour select sysdate, to_char (sysdate + 1/24/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 minute select sysdate, to_char (sysdate + 1/24/60/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 second -- cursor loop instance: -- multiple pieces of data are queried, but the data needs to be recycled one by one, similar to traversing declarev_yhzh varchar2 (20) in java; -- Define the variable user number v_phone varchar2 (11 ); -- the mobile phone number CURSOR cur_1 IS select dy. user_sid, dy. user_mobile from dx. dy_order dy; -- save the result to cur_1begin open cur_1; -- open the cursor loop -- loop fetch cur_1 into v_yhzh, v_phone; -- give the cursor values to v_yhzh exit when cur_1 % notfound in sequence; -- loop condition dbms_output.put_line (v_yhzh | '---' | v_phone); -- print the output end loop; -- close cur_1 when the loop ends. -- close the cursor end; -- end