Skip to Main Content

SQLcl

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Wrong standart format

user635344Aug 27 2018 — edited Aug 30 2018

I am getting wrong format for sql likes:

select employee_id,first_name,last_name from employees;

EMPLOYEE_ID FIRST_NAME           LAST_NAME
----------- -------------------- -------------------------
        100 Steven         King
        101 Neena         Kochhar
        102 Lex              De Haan
        103 Alexander   Hunold
        104 Bruce          Ernst
        105 David          Austin
        106 Valli             Pataballa
        107 Diana          Lorentz
        108 Nancy         Greenberg

Second varchar2 column  is not adjusted to column header (Last Name).

Any ideas?

SQL> desc employees

Name           Null?    Type

-------------- -------- ------------

EMPLOYEE_ID NOT NULL NUMBER(6)

FIRST_NAME          VARCHAR2(20)

LAST_NAME NOT NULL VARCHAR2(25)

EMAIL  NOT NULL VARCHAR2(25)

PHONE_NUMBER          VARCHAR2(20)

HIRE_DATE NOT NULL DATE

JOB_ID NOT NULL VARCHAR2(10)

SALARY          NUMBER(8,2)

COMMISSION_PCT          NUMBER(2,2)

MANAGER_ID          NUMBER(6)

DEPARTMENT_ID          NUMBER(4)

All sets are standard

Thank you

Comments

Processing

Post Details

Added on Aug 27 2018
6 comments
957 views