Home » Developer & Programmer » Forms » How will you select multiple tables in a single data block?
How will you select multiple tables in a single data block? [message #159570] Mon, 20 February 2006 06:06 Go to next message
Nilesh Kunte
Messages: 30
Registered: December 2004
Location: Indore
Member
Hi,
My problem is that "How will you select multiple tables in a single data block" ?

T&R,
Nilesh Kunte.
Re: How will you select multiple tables in a single data block? [message #159580 is a reply to message #159570] Mon, 20 February 2006 06:31 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps having a view (written upon all the tables you need) as a data block source?
Re: How will you select multiple tables in a single data block? [message #198301 is a reply to message #159580] Mon, 16 October 2006 08:48 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
No Message Body

[Updated on: Mon, 16 October 2006 12:54]

Report message to a moderator

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 Go to previous message
Littlefoot
Messages: 21818
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? http://www.orafaq.com/forum/fa/1600/0/
Previous Topic: developer 6i patch 17
Next Topic: Display Multiple language Content on Frontend
Goto Forum:
  


Current Time: Fri Sep 20 13:48:54 CDT 2024