Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 893
  • Last Modified:

SQLPlus DESC Formatting

Hello,

In SQLPlus it seems the output of a DESC command on a table does not respect COL <col_name> FORMAT Ann.  I'd like to trim the TYPE and NAME output to about 25 characters.

How can one do this?

Thanks,

Michael
Name                                                                                                                              Null?
Type
 ----------------------------------------------------------------------------------------------------------------------------------------- -
------- --------------------------------------------------------------------------------------------
 ADDITIONALACCOUNTS_ID                                                                                                             NOT NULL
NUMBER(12)
 CUMEMBERS_ID                                                                                                                      NOT NULL
NUMBER(12)
 ADDITIONALACCT
NUMBER(9)
 CREATETIMESTAMP
DATE
 UPDATETIMESTAMP
DATE
 UPDATECOUNTER
NUMBER(12)
 DELETED
NUMBER(12)

Open in new window

0
michael4606
Asked:
michael4606
1 Solution
 
MilleniumaireCommented:
Have you tried reducing the setting of linesize as this affects the column sizes used by describe.

e.g. set linesize 80
0
 
atyrsvcCommented:
Instead of DESC <table>, you can do query on DICT tables like Select * from all_tables where table_name = 'XYZ'. This query will honor your COL format. You can save this in a script like DESC1 and have tablename as parameter for easy access.
0
 
michael4606Author Commented:
Bingo - that was it.

Milleniumaire thanks for posting!
0
 
AndytwCommented:
Milleniumaire is correct, use linesize

See Extract from the Oracle Docs SQL*PlusĀ® User's Guide and Reference
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/toc.htm

<snip>
To format the DESCRIBE output use the SET command as follows:

SET LINESIZE 80
SET DESCRIBE DEPTH 2
SET DESCRIBE INDENT ON
SET DESCRIBE LINE OFF
To display the settings for the object, use the SHOW command as follows:

SHOW DESCRIBE
DESCRIBE DEPTH 2 LINENUM OFF INDENT ON
</snip>
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now