The SQL Deveoper version 17.2 puts line breaks afre IF and THEN keywords whatever options i choose in formatting options. I would like to have IF condtion THEN in one line, how can I change that ?
-- create_package_body.htm#LNPLS01381
CREATE OR REPLACE PACKAGE BODY emp_mgmt AS
tot_emps NUMBER;
tot_depts NUMBER;
FUNCTION hire (
last_name IN VARCHAR2,
job_id IN VARCHAR2,
manager_id NUMBER,
salary NUMBER,
department_id NUMBER
) RETURN NUMBER IS
new_empno NUMBER;
BEGIN
IF
last_name IS NULL
THEN
NULL;
END IF;
END;
END emp_mgmt;
/
-