displaying rows in one database block according to the focus in another database bloc
From: Manikandan <member12054_at_dbforums.com>
Date: Tue, 29 Jul 2003 08:05:35 +0000
Message-ID: <3159599.1059465935_at_dbforums.com>
Date: Tue, 29 Jul 2003 08:05:35 +0000
Message-ID: <3159599.1059465935_at_dbforums.com>
Hi,
I have two data base blocks.
One block contains the key.
[Quoted] The next block contains values for the key.(1 key can contain
many values)
If i have 10 keys in my first block and each key contains around 12
different values,
when the cursor is at first key record,my second block should have the
12 values corresponding to the first key(in first data block).
i have formed first block with key table.
the next block with value table.
The value table has values for the keys in key table in addition to key.
So how to achieve this and where(in which trigger) i can write my excute
query or any other better way of doing this operation.
Please Guide me!
-- Posted via http://dbforums.comReceived on Tue Jul 29 2003 - 10:05:35 CEST
