dbTalk Databases Forums  

displaying rows in one database block according to the focus in another database bloc

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss displaying rows in one database block according to the focus in another database bloc in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manikandan
 
Posts: n/a

Default displaying rows in one database block according to the focus in another database bloc - 07-29-2003 , 03:05 AM







Hi,
I have two data base blocks.
One block contains the key.
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.com

Reply With Quote
  #2  
Old   
Manikandan
 
Posts: n/a

Default Re: displaying rows in one database block according to the focus in another database bloc - 07-29-2003 , 06:36 AM







hI,
Thanks a lot...

--
Posted via http://dbforums.com

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.