How do I get column datatype in Oracle by sql
select field name and dataype of oracle in table by sql
Syntax:
SELECT table_name, column_name, data_type, data_length FROM all_tab_columns where table_name = ‘PS_DEPT_TBL’
Result:
select field name and dataype of oracle in table by sql
Syntax:
SELECT table_name, column_name, data_type, data_length FROM all_tab_columns where table_name = ‘PS_DEPT_TBL’
Result: