How to fetch multiple columns from cursor in Oracle?
How to fetch multiple columns from cursor in Oracle? In this article we will see… Read More
2 years ago
COLLECTIONS
How to fetch data from ref cursor in Oracle using for loop?
How to fetch data from ref cursor in Oracle using for loop? We will examine… Read More
2 years ago
Oracle function return Array of Varchar2
Oracle function return Array of Varchar2 To return an array from a function, we will… Read More
2 years ago
How To Pass Array in where clause in Oracle?
How To Pass Array in where clause in Oracle? Array can be passed in WHERE… Read More
2 years ago
How to store string array in Oracle DB?
How to store string array in Oracle DB? There are 2 types of array which… Read More
2 years ago
How to convert Array to String in Oracle?
How to convert Array to String in Oracle? We can convert an array to string… Read More
2 years ago
How to pass array in Oracle SQL query?
How to pass array in Oracle SQL query? We can use PIPELINED TABLE FUNCTION to… Read More
2 years ago
Oracle check if value exists in associative array
Oracle check if value exists in associative array: Use EXISTS collection method to check if… Read More
2 years ago
Oracle Nested table as stored procedure parameters
Oracle Nested table as stored procedure parameters Nested table to pass as a parameter to… Read More
2 years ago
How to pass collection in stored procedure in Oracle?
How to pass collection in stored procedure in Oracle? Passing collection to Oracle stored procedure:… Read More
2 years ago