Oracle Magazine, July/August 2018
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2018 116 COMMIT END Now I use the UNION ALL set operator combining data from the table and the table function SELECT FROM string_ pairs UNION ALL SELECT FROM TABLE three_ pairs STRING1 STRING2 a bb cc dd a b c d e f Next I join the table and the table function together SELECT sp string1 sp string2 sp_ string2 p3 string2 ps_ string2 FROM string_ pairs sp TABLE three_ pairs p3
You must have JavaScript enabled to view digital editions.