oranachs

 Profile Answers by oranachs Questions by oranachs

• Aug 17th, 2006

 

hai

just use subquery in for clause

ex:

for emprec in (select * from emp)

loop

dbms_output.put_line(emprec.empno);

end loop;

no exit statement needed

implicit open,fetch,close occurs

try this and send me the reply on ora.nachs@yahoo.com

Venkat

• Sep 21st, 2006

 

I think the answer is:

If your select statement retruns only one value, you can avoid using cursor:
for instance:

select fname into v_fname
from emp where empno = 10;

(here assueme that the empno is PK)

in your procedure or package or function you can declare the variable v_fname and directly use the above sql statement instead of declaring a cursor,opening, ...

Thanks.

Venkat

Venkat9999

 Profile 

• Sep 21st, 2006

 

I think the answer is:

If your select statement retruns only one value, you can avoid using cursor:
for instance:

select fname into v_fname
from emp where empno = 10;

(here assueme that the empno is PK)

in your procedure or package or function you can declare the variable v_fname
and directly use the above sql statement instead of declaring a cursor,opening,
...

Venkat

Jagadish V

• Nov 24th, 2006

 

if you need to perform manipulations from the output of the select statement which results multiple rows ,the cursor need to be used.

Tanveer Islam Siddiqui

• Nov 24th, 2006

 

U have 2 options to do it..

1st) Use Pl/SQL Table...

2nd) Create Temporary Table and use it in place of Table...

Thulasidas

• Nov 26th, 2006

 

Well there may be several ways for not to use a cursor. But a good programming practice suggests the use of cursors as much as possible for performance and efficiency purpose.

srinivas

• Nov 29th, 2006

 

insted of using cursor we will use attribute data types %type and %rowtype to load data in pl/sql

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 8th, 2008

 

You can use bulk binding to avoid cursors. It improves performance by minimizing context switches sql and pl/sql. When you are hadling large volume of data then better to use bulk binding.

KSPRADEEP

• Oct 17th, 2012

 

Yes we can ..
Instead of cursor we using bulk collection or bulk binding or using %type and %rowtype

Ashish

• Jun 12th, 2014

 

You can use MERGE statements in Oracle to avoid looping through Conventional cursors. It will save lot of time