(DEPARTMENT_ID IN NUMBER DEFAULT 10, DEPARTMENT_NAME IN VARCHAR2 DEFAULT 20, MANAGER_ID IN NUMBER DEFAULT 10, LOCATION_ID IN NUMBER DEFAULT 10, GOODS_ID IN NUMBER DEFAULT 10)

BEGIN

SELECT DEPARTMENT_NAME INTO p_department_name

from dbuser where department_id = 1;

dbms_output.put_line('Department name for ID = 1 is : ' || p_department_name);

NULL;

END ADD_DEPARTMENTS;

END;