We will examine different ways to fetch data from ref cursor.
We will use SYS_REFCURSOR as ref cursor variable as its a week type of cursor.
It will …
To return an array from a function, we will store the array inside database.
Oracle will raise compilation error if we don't store the data inside DB.
Array can be passed in WHERE clause of sql query and in PLSQL as well.
But to use any array in a SQL query, we will store the array data inside …
There are 2 types of array which are persistent in type. So they can be stored in Oracle DB.
--How to…
We can use PIPELINED TABLE FUNCTION to pass an array to Oracle SQL query.
We can also use normal function instead of Pipelined table function but from performance perspective Pipelined table function …