select table_name||'.'||column_name||'  '||decode(data_type,'CHAR',data_type||'('||data_length||')','NCHAR',data_type||'('||data_length||')','VARCHAR2',data_type||'('||data_length||')','NVARCHAR2',data_type||'('||data_length||')', 'NUMBER',DECODE(data_precision,NULL,'NUMBER',data_type||'('||data_precision||','||data_scale||')'),data_type) FROM user_tab_columns WHERE table_name NOT LIKE 'BIN%' ORDER BY 1;