SQL> Create or Replace Procedure Test2 As 2 Begin 3 INSERT INTO YANGBC.A1 VALUES ('procte1', 'prote2'); 4 end; 5 /
The process has been created.
SQL> SELECT * from yangbc.a1;
ID Name ---------- ---------- GFH FGHFH FGHGFH FGH
SQL> EXECUTE TEST2;
The PL / SQL process has been successfully completed.
SQL> L 1 * Select * from yangbc.a1sql> Run 1 * select * from yangbc.a1
ID Name -------------------- GFH FGHFH FGHGFH FGHPROCTE1 PROTE2
