Re: add sysdate to column name

It looks like you already have your answer but I thought I'd throw this out anyway. It is similar. Perhaps right for a package.

DECLARE SysdateName varchar2(20) := to_char(sysdate, 'mm/dd/yyyy');

create_insert_sql varchar2(1000);

BEGIN create_insert_sql := '
create table test_column_name as
select ''' || SysdateName || ''' as "' || SysdateName || '" from dual ';

execute immediate create_insert_sql;

dbms_output.put_line(create_insert_sql);

END;
/

select * from test_column_name;

drop table test_column_name; Received on Thu Sep 27 2007 - 13:50:11 CDT