我的论坛主题

• 请教一个SQL语句

  2008-05-16 13:17:54   /   Oracle开发

  SQL文如下，select (select max(st) from(select substr(t1.text,level,1) st from dual connect by level< length(t1.text)+1)),T1.text from aa T1-------------表结构--------------create table aa(id varchar2(9),text varchar2(90),primary key(ID));-------------数--据-------------insert into aa(id,text) values('1','123');insert into aa(id,text) values('2','345');insert into aa(id,text) values('3','6');-------------目前结果-------------3123334536-

  查看(517) 评论(16)