Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Design question
start with any way you can determine to get it to work, then do some tuning.
"most efficient" is always relative to the parameters by which efficiency is
being measured.
"Jim Poe" <jpoe_at_fulcrumit.com> wrote in message
news:9q7dmc$dat_at_dispatch.concentric.net...
> I have two tables:
>
> Create table CUST (
> Cust_id number(10),
> Name_First varchar2(10),
> Name_Last varchar2(15));
>
> Create table CUST_AKA(
> Cust_Aka_Id number(10),
> Name varchar2( 15 ),
> Cust_Id number(10));
>
> I would like to create a view with Cust_Id, Name.
>
> For any Cust_ID, the view would consist of 2 or more rows. One where Name
=
> Cust.Name_First, one where Name = Cust.Name_Last, and one row each for all
> values in Cust_AKA.Name.
>
> What would be the most efficient way to accomplish this?
>
> Thanks
>
> --
> Jim Poe (jpoe_at_fulcrumit.com)
>
>
Received on Sat Oct 13 2001 - 13:51:20 CDT