merge into jinxin_test t1
using (SELECT '2013-11-05' AS pre_date ,'18:15:00' as pre_time FROM dual) T2
on (t1.pre_date =t2.pre_date and t1.pre_time =t2.pre_time )
merge into jinxin_test t1
using (SELECT '2013-11-05' AS pre_date FROM dual) T2
on (t1.pre_date =t2.pre_date )
when matched then update set real='25.1',yn_short='33.1'
when not matched then insert (pre_date,pre_time,real,yn_short) values('2013-11-05','18:15:00','20','30')
using (SELECT '2013-11-05' AS pre_date ,'18:15:00' as pre_time FROM dual) T2
on (t1.pre_date =t2.pre_date and t1.pre_time =t2.pre_time )
when not matched then insert (pre_date,pre_time) values('2013-11-05','18:15:00')
merge into jinxin_test t1
using (SELECT '2013-11-05' AS pre_date FROM dual) T2
on (t1.pre_date =t2.pre_date )
when matched then update set real='25.1',yn_short='33.1'
when not matched then insert (pre_date,pre_time,real,yn_short) values('2013-11-05','18:15:00','20','30')