Skip to Main Content

SQL & PL/SQL

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!

Select on Cursor in oracle 10g

ThejAug 28 2013 — edited Aug 28 2013


Hi Experts ,

I have a cursor which selects the data from another source.

Now I am having a problem with this cursor because i cannot put any where condition as it takes huge time to retrive the data (data's are retrived from views)

The "select *  from Source" works fine as it takes less  time.

Now how can I filter the cursor  (select *  from Source ) and load the data into table ?

can I use "select col from curosr where  cond= 'something' ?"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2013
Added on Aug 28 2013
3 comments
670 views