67,549
社区成员




select substr(sql_text,1,35), count(*)
from v$sqlarea
group by substr(sql_text,1,35) having count(*) > 50;
sprintf(tmpbuf, "select user_id,user_name,logic_code from t_user a where a.logic_%d in (%s)", i,user_name);
select REGEXP_SUBSTR(&str,'[^,]+',1,level) as value_str
from dual
connect by level <= length(&str)-length(replace(&str,',',''))+1;
create or replace type str2tblType as table of varchar2(4000);
create or replace
function str2tbl
( p_str in varchar2,
p_delim in varchar2 default ',' )
return str2tblType
as
l_str long default p_str || p_delim;
l_n number;
l_data str2tblType := str2tblType();
begin
loop
l_n := instr( l_str, p_delim );
exit when (nvl(l_n,0) = 0);
l_data.extend;
l_data(l_data.count) := ltrim(rtrim(substr(l_str,1,l_n-1)));
l_str := substr( l_str, l_n+1 );
end loop;
return l_data;
end;
select * from TABLE(cast(str2tbl('123,abc') as str2TblType));
select * from tab_ a where a.u_ in(.........)
类似于这样的语句,in 中可拼入的元素个数是有限的(忘记多少个了)...