在线求教sql简单语句

[lizhiwo_wo]

我如何向 reg_hm_12590表结构如下
HM VARCHAR2(11) --姓名
DJRQ DATE --登记时间
的表内插一条记录 xiaoli, 20050113201424

[ORARichard]

insert into reg_hm_12590(hm,djrq) values('xiaoli',to_date('20050113201424','yyyymmddhh24miss');

[baojianjun]

TO_DATE(string,’format’)

将一和字串转换为ORACLE的日期。如：

Insert into demo(demo_key,date_col)
Values(1 , to_date(’04-Oct-1999’, ‘DD-Mon-yyyy’) );

[qiaozhiwei]

insert into reg_hm_12590 (HM,DJRQ) values ('xiaoli',to_date('20050113201424','YYYY-MM-DD HH24:MI:SS'));

[ORARichard]

--or

insert into reg_hm_12590 values('xiaoli',to_date('20050113201424','yyyymmddhh24miss'));

--or

insert into reg_hm_12590(hm,djrq)
select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;

--or

insert into reg_hm_12590
select 'xiaoli',to_date('20050113201424','yyyymmddhh24miss') from dual;

[ORARichard]

第一个少了个），加在结尾的分号前

[GerryYang]

insert into reg_hm_12590 (HM,DJRQ) values ('xiaoli',
to_date('20050113201424','YYYYMMDDHH24:MI:SS'));

[yxxx]

答案已经有了:)