Sitecore XM Cloud, Ordercloud, CDP, Personalize, ContentHub and Send
Sitecore XM Cloud, Ordercloud, CDP, Personalize, ContentHub and Send
Friday, October 11, 2013
How to check coloum type, coloum default value and coloum length 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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment