oracle 语句

insert into DYDATAMAIN(id,userno,meterno,auditbn,setmanname,ilevel) values (15,1,1,1,'冰冰妹纸',3);
select * from DYDATAMAIN where setmanname='冰冰妹纸'and auditbn=1 order by to_number(ilevel) asc,to_number(id) asc

update DYDATAMAIN set useraddr='新庄市五权路六段7巷1号1楼'; 
  

 

insert into JZQDATAMAIN(id,xqname,xqaddr,auditbn,setmanname,ilevel) values (2,'幸福六合门9号楼','建设路134号',1,'冰冰妹纸',2);        

select * from JZQDATAMAIN where setmanname='冰冰妹纸'and auditbn=1 order by to_number(ilevel) asc,to_number(id) asc   

update JZQDATAMAIN set datatimefinish = to_date('2019-07-19 17:00:00','yyyy-mm-dd hh24:mi:ss');              

posted @ 2017-05-05 11:53  哦~哦  阅读(102)  评论(0编辑  收藏  举报