In this article we will see how to fetch multiple columns and rows from a cursor.
We will check 3 ways to fetch multiple columns from a cursor:
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 convert an array to string both in SQL and PLSQL.
In Oracle SQL we have a predefined aggregate function LISTAGG which can be used to convert an Array …
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 …
Use EXISTS collection method to check if any value exists in associative array or not.
--Oracle check if value exists in associative array-- SET SERVEROUTPUT ON; DECLARE TYPE T_NUM IS TABLE OF…
Nested table to pass as a parameter to stored procedure: