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

PDF to Text Covert by Oracle Apex

Here are the steps to convert and get the character into a region by Oracle Apex. Step1.  Create a page and Copy-Pest the below code into Pa...