|
|
|
Re: How will you select multiple tables in a single data block? [message #198339 is a reply to message #198301] |
Mon, 16 October 2006 12:50 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Digging through the past? I bet you found a zillion interesting things there.
I agree, it is possible to create a block based on a stored procedure (both PL/SQL table type and REF CURSOR type). But, why didn't you mention all possibilities? Like a table, a view (non-updateable, updateable, view with INSTEAD OF triggers), a FROM clause query, or you don't have to base a block on anything (so called control block), and perhaps something else which ran off my mind.
Gosh, I just can't understand why would anyone resurrect a long-time-dead topic?
|
|
|