Oracle Magazine, July/August 2018
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2018 113 And I see MY_ STRING PGITKKZYAV IYXWISVYAC ZTTQATVKLC MJVAXASRNC CHOFPTGQTR And there it is a table function As we have all come to expect with Oracle Database the SQL engine does most of the heavy lifting for us when it comes to table functions When you call your function inside the TABLE clause of a SELECT statement the SQL engine transforms the set of data returned by the function into a relational result set This result set can then be manipulated like a result set from a table or a view When each element of the collection type is a scalar value as is the case with strings_ t above the name of the single column for that result set is automatically set to COLUMN_ VALUE You can change it of course with a column alias as I showed above When you are returning a collection of object types possible since Oracle9i Database or of records possible in Oracle Database 122 and higher the names of the object type attributes or record fields can be referenced as individual columns Heres an example
You must have JavaScript enabled to view digital editions.