Tag Archives: Oracle

Select from PL/SQL table

This example shows how to make a select from the pl/sql collection (table). First we need the ORACLE type definition with lets say two fields: and the pl/sql collection defintion: Somewhere in your code you would need to declare your variables and initialize the collection: finally we want to select our issues and sort it