Question

Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 ?

Answer 1

You can create one or more PL/SQL procedures

 

DELIMITER $$ 

CREATE PROCEDURE my_procedure() 

BEGIN 

Insert into student_data values (...);

END $$ 

DELIMITER ;

 

Create procedure get_data(p_reg_num IN varchar2) 

begin

select * from student_data where reg_num = p_reg_num;

end;