Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

If/then formatting in sql developer

291771Oct 2 2017 — edited Oct 18 2017

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;

/

-

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2017
Added on Oct 2 2017
2 comments
546 views