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 View Comments

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

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

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

Some Interesting and important built in packages in Oracle

DBMS_JOB : To schedule jobs. DBMS_SCHEDULER: Extended the functionalities of DBMS_JOB. UTL_SMTP: To send mails. UTL_HTTP: To open Web APIs (URLs). DBMS_LOB: Very interesting and useful. Programmatic...

Gavi Y.

0 0

Interview questions on Packages in Oracle

Let me list few standard questions asked in the interviews on plsql package. 1. Why packages are used? What are it's advantages? 2. Name few bulin-in Oracle packages. 3. Can we have a function or procedure...

Gavi Y.

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

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

Oracle is best in market as teradata ?

8 Answers

Hi what is the Normalization? and the types?

10 Answers

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

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

Migrate

Class

Subject

Chapter

Migrate to

Concept Solution

Migration Successful

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.