select case data_type
when 'DATE' THEN
'to_char(SY.'||column_name || ',''yyyy-MM-dd'') AS SY_' || column_name || ','
ELSE
'SY.'||column_name || ' AS SY_' || column_name || ','
END
from user_tab_columns
where table_name = 'RIG_EVA_TEST';
转载于:https://my.oschina.net/u/2446847/blog/1536358