Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Any Alternative to CURSOR in Oracle

749426Feb 4 2010 — edited Feb 4 2010

HI,
i have developed two tables those are BTN_TEMP1(TNO,NAME,TID) and QW_TEMP1(TNO,TID,ACC_NAME) and also i developed one cursor that reads all the records one by one from BTN_TEMP1 and compares TNO,TID in BTN_TEMP1 with TNO,TID in QW_TEMP1 table.IF any match found it will insert NAME of BTN_TEMP1 into another table.

Here my tech lead told me that not to use CURSOR because it will take much time to process (In fact in my project BTN_TEMP1 table contains 1.5 million records).
Friends please help me here how can compare all the records of first table with all the records of second table.

I've only 2 months of experience in ORACLE that why i'm asking the question
IS there any alternative to cursor in oracle which can compare bulk records at a time?

Please pardon me if my question is wrong.
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2010

Added on Feb 4 2010

#general-database-discussions

2 comments

1,148 views