Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
OO4O and Wizards [ARCHIVE]
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 2, 2012 11:48 PM by
How to fetch columns in cursor using FETCH?
Nov 1, 2012 5:58 AM
create or replace PROCEDURE newprocedur(outname OUT VARCHAR2,outroll OUT NUMBER) AS
CURSOR c1 IS
select Name,Rollno,Section from emp;
fetch c1 into outname,outroll;
Here out of 3 columns in cursor is it possible to fetch only two columns using FETCH like i did above??
Edited by: im_asa on Nov 1, 2012 3:58 AM
This content has been marked as final.
Show 1 reply
Re: How to fetch columns in cursor using FETCH?
Nov 2, 2012 11:48 PM
in response to
If you need only two why to fetch three ?
Just doing it by yourself will show you what will happen.