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

Starter on exception handling

Just run these two blocks individually, observe the output and comment on what do you understand from it. SET SERVEROUTPUT ONDeclareCursor C is select * from emp;i c%rowtype;BeginFetch C into i;End; SET...

Gavi Y.

0 0

How does a SQL Query Execute inside Oracle? What are the steps followed in the background?

The above snapshot says it all. Hence it is said, 'Picture says it all'. Basically, there are 4-5 steps. There are two possible ways of query being executed. 1. Soft Parse- Improves performance....

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

SQL Subqueries - Used in various ways

If you master the concepts of subqueries, you would gain a lot of flexibility in writing complex SQL queries. Let's not get into Correlated subqueries, let us see the different versions of nested subquery...

Gavi Y.

1 0

New features of Oracle 23ai

2 of the new features of Oracle 23ai (previously Oracle 23c) with respect to SQL are discussed. 1. Boolean datatype included in SQL. Previously, boolean was not part of SQL, but belonged to Oracle...

Vinayak V Dabgar

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

What is oracle ACID?

15 Answers

Oracle is best in market as teradata ?

8 Answers

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

15 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

Hi what is the Normalization? and the types?

10 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.