给数据库中的表造数据

mysql造数据
insert INTO tj_nsr (org_id,org_name,nsrsbh,nsrmc,sssq,sksbsl,kpl,kpje,se,writetime) values
("10100000000","Johor","445202790204341","BAN JOO HIN","2016-03",FLOOR(RAND() * 10000),FLOOR(RAND() * 10000),FLOOR(RAND() * 10000),FLOOR(RAND() * 100),NOW());
oracle造数据
insert INTO tj_nsr (id,org_id,org_name,nsrsbh,nsrmc,sssq,sksbsl,kpl,kpje,se,writetime) values

(10000010,10100000000,'Johor',461351248819223,'BAN JOO HIN',to_date('2016-03-26','yyyy-mm-dd'),trunc(dbms_random.value(0,10000)),trunc(dbms_random.value(0,10000)),trunc(dbms_random.value(0,10000)),trunc(dbms_random.value(0,10000)),sysdate);

如何向 Oracle 表中的 Date 字段插入日期及时间

insert into  table(j) values(to_date('2000-11-26 00:04:47','yyyy-mm-dd hh24:mi:ss'));