Skip to Main Content

SQL & PL/SQL

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!

sqlplus command describe wrapping

672949Nov 30 2008 — edited Nov 30 2008
Hi,

I would like to know why the output of describe command depends of linesize setting and how can I "normalize" it. Examples
SQL> set linesize 80
SQL> describe 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)
SQL> set linesize 1000
SQL> describe 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)
Thanks.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 28 2008
Added on Nov 30 2008
6 comments
1,183 views