Oracle stored procedure and serialized write demo

Oracle stored procedure and serialized write demo 1. create an Oracle stored procedure, set a parameter n, run the stored procedure, and pass the parameter n. After the execution, the output is five times hello world. Note: The for loop is used in the stored procedure, run exec [java] create or replace procedure Hello (n in number) is begin for I in 1 .. n loop dbms_output.put_line ('Hello World'); end loop; end;/[java] -- open the output set serveroutput on; [java] -- execute this function execute hello (5 ); 2. create a sequence (Initial Value 1030, step 1), and use this sequence to insert two data records to the emp table (the sequence creation statement and the data insertion statement are required) [java] create sequence myse increment by 1 start with 1030; insert into emp_xxx values (myse. nextval, 'zhang Wuji ', 'manager', '12-January--10', 10 );