Shulou(Shulou.com)05/31 Report--

How to use the oracle pipeline function correctly? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Oracle pipeline function is a special kind of function, and the return value type of oracle pipeline function must be a collection.

If you need to output some information during the execution of the function in real time on the client side, you can use the pipeline function (pipeline function) after oracle9i.

The keyword PIPELINED indicates that this is an oracle pipeline function, and the return type of the oracle pipeline function must be a collection.

-- create a collection to accept the returned value 1st.create or replace type type_split as table of varchar2 (4000) -- create the information output by the pipeline function create or replace function split (p_string varchar2, p_sep varchar2: =',') return type_split pipelined--dbms_output, which needs to be returned to the client at once after the server executes the entire function-- pipelined indicates that this is a pipeline function, and the return type of the oracle pipeline function must be a collection-- the PIPE ROW statement is used to return a single element of the collection asv_string varchar2 (4000): = p_string Idx Number;beginloop--idx is the first, where idx: = instr (v_string, p_sep); the data before if idx > 0 then--, is added to the data after Row/, is the string pipe row (substr (v_string, 1, idx-1)) for the next cycle; v_string: = substr (v_string, idx + length (p_sep)); returnreturn after elseexit;end if;end loop;-- execution; end After reading the above, have you mastered how to use the oracle pipeline function correctly? test:select a. Custache poreb. Columnkeeper value proqepi from (select cust_po,proqepi from cux_custpo_info_t where cust_po='PX90806001-4') a, (table (a. Proqepigrammar) b after reading the above, have you mastered how to use the pipeline function correctly? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.