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 ?