oracle 查看表构造信息

oracle 查看表结构信息select COLUMN_NAME,DATA_TYPE,DATA_LENGTH from all_tab_columns where table_name

oracle 查看表结构信息
select COLUMN_NAME,DATA_TYPE,DATA_LENGTH from all_tab_columns where table_name='大写表名'