true

Learn Oracle PL/SQL from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

How To Return a Result Set from a Stored Procedure

22/02/2017 0 0

One of the easiest ways to tackle such Real Time scenarios is through use of Oracle Defined "SYS_REFCURSOR" or "REF CURSOR".

We can create a Procedure with an out parameter of Type SYS_REFCURSOR and in the execution block we can open a cursor variable of same type as SYS_REFCURSOR for the required Select Query.

I will update this with a sample Code shortly.

Till then Cheers and Enjoy!!

0 Like 0 Dislike

Follow 0

Other Lessons for You

Common mistake even experienced programmers make in Plsql.

Hope, you are aware of Procedures in Plsql. Let us discuss one simple thing which we should always remember while writing the datatype of a parameter for a procedure or a function. Eg: Create or replace...

Gavi Y.

0 0

SQL - Structured Query Language - DQL Commands - SELECT

Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL...

Kasyap Kasyap

2 0

Exception Handling topics

Here, I am only going to list the topics which one should consider to master Exception Handling. 1. Types of errors in Pl/sql- Compile time and Run time 2. How to read and understand the Compile time...

Gavi Y.

0 0

How To Create The Java Souce In Oracle PLSQL?

Requirement: How to find the list of files in specified directory? Step1 : First find the JDK Install or not in the oracle, to find jdk version please run the below sql. SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version')...

Murali Krishna

0 0

Amazon written test for experience

For the below written test answer I defined with "*" at the end of the options NULL is the same as 0 for integer the same as blank for character * the same as 0 for integer and blank for character the...

Suresh

0 0

Find Oracle PL/SQL near you

Looking for Oracle PL/SQL ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Oracle PL/SQL Questions

Oracle is best in market as teradata ?

8 Answers

I have theoretical knowledge on PLSQL but I am not good in Hands-on PLSQL and how PLSQL works in a project, Can anyone help me?

29 Answers

Do ORACLE/PLSQL is having scope in IT industry ? is it use full for a IT career?

15 Answers

Hi what is the Normalization? and the types?

10 Answers

What is oracle ACID?

15 Answers

Looking for Oracle PL/SQL Classes?

The best tutors for Oracle PL/SQL Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Oracle PL/SQL with the Best Tutors

The best Tutors for Oracle PL/SQL Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.