WAP to use procedure in pl/sql
step-1 create a table
create table student(stdRollNo number, stdName varchar2(25)
, stdClass varchar2(25)); RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE PL/SQL COMMAND step-2 create or replace procedure print(vid number,vname varchar2(25)) is begin insert into student(stdRollno,stdName) values(vid,vname); end print; RUN these COMMANDs, IF SUCCESSFULLY RUN THEN WRITE following
COMMAND
step-3
begin
print(01,'xyz');
end print;