Create an anonymous PL/SQL block to enroll a Student

Create an anonymous PL/SQL block to enroll a student in a particular class. You will use the ENROLLMENTS table. Accept a STU_ID and CLASS_ID as input parameters. Use "today's date" for the ENROLLMENT_DATE and the string "Enrolled" for the STATUS.
  • Interview Candidate
  • 3
  • 7689

Showing Answers 1 - 3 of 3 Answers

Mohana Thangavelu

  • Sep 9th, 2017
 

Begin
Insert into enrollments values(&stud_Id,&class_Id,sysdate);
Commit;
End;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions