select t1, row_number() over ( partition by t1 order by t1), t2.* from (select 'X' as t1 from dual UNIOn select 'Y' from dual) t1, table (sys.odcivarchar2list('a', 'b', 'c')) t2;
select t1, row_number() over ( partition by t1 order by t1), t2.* from (select 'X' as t1 from dual UNIOn select 'Y' from dual) t1, table (sys.odcivarchar2list('a', 'b', 'c')) t2;名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
