Fetch the records from more than one table using cursors

kathir · New User Joined: 03 May 2005 Posts: 4

Hi Guys,

Can we fetch the records from more than one table using cursor ?

avalanches · New User Joined: 10 May 2005 Posts: 28

Hi,

A cursor is a temporary logical table. When it is declared, the logical table is created. So, the cursor can be declared for more than one tables.

Cheers....

ovreddy · Posted: Sun May 15, 2005 12:39 pm

Hi Kathir,

Yes you can why not?

For example if you have a View joining two tables and have a cursor on it. Then why cursor for two tables is not possible. Its possible but some limitaions like updations are not allowed like views.

Thanks,
Reddy.