Search This Blog

Tuesday, February 6, 2018

How to get Column data type

SELECT  all_tab_columns.COLUMN_NAME,all_tab_columns.DATA_TYPE 
FROM 
all_tab_columns  
where 
all_tab_columns.TABLE_NAME='Table_NameAND COLUMN_NAME='Column_Name'

No comments:

Post a Comment

Error From Interactive Grid - Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row locking.

Error: Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row ...