Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Blocks and multiple tables

Re: Blocks and multiple tables

From: Yosi Greenfield <ygreenfield_at_compuserve.com>
Date: Wed, 03 Nov 1999 14:47:14 -0500
Message-ID: <38209142.6145E5AA@compuserve.com>


Create a non-database field in the block, and in the block's post-query trigger populate it with a select <field> into :non-db-field from <secondary_table>.

That field is then not updateable, by the way.

hth,

y

KRM wrote:

> Hello.
>
> I would like to be able to have a block display 10 records at a time.
> This is quite easy for a block that is getting data from only one
> table. However, I need to also include a field from another table. The
> data for these two tables are related in such a way that there is a one-
> to-one relationship. How can I set up my form so that I have fields
> from multiple tables in the same block?
>
> Thanks in advance!
> Kristen
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 03 1999 - 13:47:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US