oracle数据库里面的字符串转成数字类型,答:create table a (id number,name varchar2(10));insert into a values (1,'aa');insert into a values (2,'bb');insert into a values (3,'cc');cimmit;取当前行的前一行数据 select id,name,lag(id,1)over(order by id),lag(name,1)over(order by id) from a where id in (...