create table usertable (id number, name varchar2(100),createdate date default sysdate);

 alter table marketing_info modify marketing_setdate date default sysdate;