Guest User

Guest User

  • Tech Writer
  • 41
  • 15.8k

PL/SQL code

Jul 29 2015 4:32 PM

Hi guys im doing an assignment for commercial programming and have this question that I am stuck with, can anyone help please it will really be appreciated.

Question is

Write PL/SQL code that will insert a new record into the departments table, who’s "DEPARTMENT_NAME" is entered by the user at run time. You are required to use the sequence departments_SEQ, that is already created, to ensure that a unique value is used for the “DEPARTMENT_ID”. The rest of the fields must be left empty for the time being.

 
thanks