| Combine cursors [message #374316] |
Tue, 05 June 2001 09:40 |
Bill Warneke
Messages: 1
Registered: June 2001
|
Junior Member |
|
|
I have a question regarding cursors. I have a report that gathers info from 6 different tables. The query was slow, so I decided to break up the query and create 3 separate cursors. I now need to combine those cursors into a single cursor to send back to my report. Is this possible?
I also tried to do a subquery within my main cursor select statement (fieldxx as (select xxx from abc where xx = xx), but either this approach isn't possible or my syntax is wrong. Any ideas?
I've also tried to do a separate update command after the main cursor is complete. (update cursor1 set xx = xx where table.field = cursor1.field). Similar problems as the last paragraph. Is this valid?
Sorry for the length of the post. Being new to PL/SQL, can anyone point me in the most logical direction?
Thanks for your help.
Bill
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
