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
                           

oracle 语句

原文：http://www.cnblogs.com/zzyrunning/p/6812266.html