//获取不能转换为整数的数据
select 字段 from 表 where regexp_replace(字段,'\d','') is not null
//orcale设置自增字段
create sequence S_表
minvalue 1 //步长
maxvalue 9999999 //最大数
start with 1
increment by 1
cache 50;
//查询序列当前值
select s_表.currval from dual;
//查询序列下次值
select s_表.nextval from dual;