1:查询最大ID
SELECT MAX(列名) FROM 表名;
例:SELECT max(id) FROM t_user;
2:调整初始值
ALTER TABLE 表名 ALTER 列名 RESTART WITH 初始值;
例:alter table t_user alter id restart with 100;
3:insert into ... select...语句,主键非自增(更换红色位置)
insert into t_table(id)
select (select max(id) fromt_table) + ROW_NUMBER() OVER()
4:多行合并(更换红色位置)
selectA,replace(replace(xml2clob(xmlagg(xmlelement(NAME a,B||','))),'<A>',''),'</A>',' ') from
T_TABLE gruop byA