select Lower(column_name) "字段名",decode(data_type,'VARCHAR2',data_type||'('||data_length||')','NUMBER',data_type||'('||data_length||')') "字段编码", (select decode(column_name,c.COLUMN_NAME,'TRUE','FALSE')