Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to write a stored procedure in Oracle 1
- Thread starter shyamal
- Start date
-
1
- #2
CREATE OR REPLACE PROCEDURE <proc_name> IS
i NUMBER := 1;
BEGIN
WHILE ( i <= 5000)
LOOP
INSERT INTO t00 values(i);
INSERT INTO t50 values(i);
i := i + 1;
END LOOP;
COMMIT;
END;
/
executing the procedure from sqlplus---
SQL> exec <proc_name>
or
using pl/sql
begin
<proc_name>
end;
/
i NUMBER := 1;
BEGIN
WHILE ( i <= 5000)
LOOP
INSERT INTO t00 values(i);
INSERT INTO t50 values(i);
i := i + 1;
END LOOP;
COMMIT;
END;
/
executing the procedure from sqlplus---
SQL> exec <proc_name>
or
using pl/sql
begin
<proc_name>
end;
/
- Thread starter
- #3
- Status
Similar threads
