Oracle Magazine, July/August 2018
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2018 115 STRING1 STRING2 a b c d e f HOW CAN I USE THE FUNCTIONS RESULT SET Once youve nestled your function call inside the TABLE clause you can use the result set just as you would the result set from a table or an inline view You can join to that set you can use columns in WHERE clauses and you can use set operators Here are some examples using the three_ pairs function plus this simple table CREATE TABLE string_ pairs string1 VARCHAR2 10 string2 VARCHAR2 10 BEGIN INSERT INTO string_ pairs VALUES a bb INSERT INTO string_ pairs VALUES cc dd
You must have JavaScript enabled to view digital editions.