查询数据库的表名称和列名称

SELECT * FROM (
select TABLE_NAME,COLUMN_NAME,DATA_TYPE   from user_tab_columns where ( TABLE_NAME like 'T_%' or TABLE_NAME like 'V_%')   
UNION
select TABLE_NAME,COLUMN_NAME,DATA_TYPE  from ALL_TAB_COLS where  TABLE_NAME IN ('T_XTYH','T_ERP_JC_SJZD','T_ERP_JC_SJZDMX')  and owner like 'SDEER%'
) A order by TABLE_NAME;

SELECT * FROM user_tab_columns;

SELECT * FROM ALL_TAB_COLS;

select table_name,tablespace_name,temporary from user_tables ;
select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns where table_name='T_DRP_XS_POS';