Skip to Main Content

Oracle Database Discussions

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.

how to set column size in sqlplus.exe ?

bootstrapJun 21 2010 — edited Apr 22 2012
SQL> select * from dba_cons_columns where user='USER1' and table_name='PARENT1';

OWNER                          CONSTRAINT_NAME
------------------------------ ------------------------------
TABLE_NAME
------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
  POSITION
----------
USER1                          PARENT1_PK
PARENT1
COL2
         2


OWNER                          CONSTRAINT_NAME
------------------------------ ------------------------------
TABLE_NAME
------------------------------
COLUMN_NAME
--------------------------------------------------------------------------------
  POSITION
----------
USER1                          PARENT1_PK
PARENT1
COL1
         1
doesn't it seems bit ugly to see these data.Why length of columns is so long ?please tell how to set the length of columns and other parameters so that data that is displayed should come out in screen in a well managed and beautiful way.
Like this:
OWNER     CONSTRAINT_NAME     TABLE_NAME       COLUMN_NAME   POSITION
-----------     ----------------------------     ------------------        ---------------------    --------------
USER1        PARENT1_PK              PARENT1             COL2                  2
USER1        PARENT1_PK              PARENT1             COL1                  1
I have written this by hand. How to get display in sqlplus.exe ?
This post has been answered by Aman.... on Jun 22 2010
Jump to Answer

Comments

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

Post Details

Locked on May 20 2012
Added on Jun 21 2010
14 comments
383,404 views