表结构的查询

select t.COLUMN_NAME "代码",t.DATA_TYPE||'('||t.DATA_LENGTH||')'

"数据类型"  from all_tab_columns t where table_name='T_SERVICE_064_SELBROKER';