IN 子句元素个数超过1000处理
摘要:一、解决方法一/* Oracle Database 10g Release 10.2.0.1.0 */CREATE OR REPLACE TYPE t_num_arr IS TABLE OF VARCHAR2(30);/CREATE OR REPLACE FUNCTION f_num_arr(str VARCHAR2) RETURN t_num_arr pipelinedIS l_start NUMBER := 1; l_end NUMBER;BEGIN l_end := INSTR(str,',',l_start); WHILE l_end >0 loop pipe R
阅读全文
posted @
2011-12-13 15:20
洞幺人生
阅读(301)
推荐(0)