Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
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_Name' AND COLUMN_NAME='Column_Name'
No comments:
Post a Comment