create table a(
id integer primary key,
datea date default sysdate,
name varchar2(10),
num number(20)
)
insert into a values(user_text.nextval,to_date(to_char(sysdate,'YYYY-MM-DD'),'YYYY-MM-DD'),'s',5)
id integer primary key,
datea date default sysdate,
name varchar2(10),
num number(20)
)
insert into a values(user_text.nextval,to_date(to_char(sysdate,'YYYY-MM-DD'),'YYYY-MM-DD'),'s',5)