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.