Friday, October 11, 2013

How to check coloum type, coloum default value and coloum lenght in oracle.

Below query will give this result.
 
SELECT atc.TABLE_NAME, atc.OWNER, atc.DEFAULT_LENGTH, atc.DATA_DEFAULT,
       atc.COLUMN_NAME,
       atc.DATA_TYPE
FROM  ALL_TAB_COLUMNS atc where lower (atc.COLUMN_NAME)='XXXX' and atc.TABLE_NAME ='XXXXXXXXXXx'

No comments:

Post a Comment