declare 
this_date varchar2(15); 
begin 
select (concat(concat('''',to_char(sysdate,'DD-MON-YYYY')),'''')) into this_date 
from dual; 
execute immediate 'create table test(col1 date) 
partition by range(col1) 
(partition p1 values less than ('||this_date||'), 
partition p2 values less than (maxvalue))'; 
end; 
/