SQL> Create or Replace Procedure Test3 As 2 Begin 3 INSERT INTO YANGBC.A1 VALUES (To_Char (Sysdate), 'sysdate'); 4 End; 5 /
The process has been created.
SQL> Execute Test3;
The PL / SQL process has been successfully completed.
SQL> SELECT * from yangbc.a1;
ID Name ---------- ---------- GFH FGHFH FGHGFH FGHPROCTE1 PROTE2PROCTE1 PROTE205-2 February -05 Sysdate
6 lines have been selected.
