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: Need help accessing attribute in method

Re: Need help accessing attribute in method

From: Bit Twister <BitTwister_at_localhost.localdomain>
Date: Mon, 01 Dec 2003 18:06:04 GMT
Message-ID: <slrnbsn0jh.313.BitTwister@wb.home>


On Mon, 1 Dec 2003 17:21:07 +0000 (UTC), Greg wrote:
> I am trying to build a simple object-relational DB based on an air traffic
> control system. I am going to have object tables for plane and runway with a
> relation table called flight_info which will contain pointers to the other 2
> tables so that I can planes to runways.
>
> I am trying to create a method for the plane table that will calculate the
> stopping distance of a plane based on various parameters. One of these
> parameters is the number of passengers on a particular flight which is
> stored in the flight_info table. I'm not sure if I can access this attribute
> but would like to ask if I can or what my options are regarding this.

It would seem easier to me to have table about aircraft types with the columns you need for the math. That way as new models are created you do not have to modify your function, just add to the table.

Your function gets the model type from the flight_info table or feel free to pass arguments to your function to allow it to hunt down more information in other tables. Received on Mon Dec 01 2003 - 12:06:04 CST

Original text of this message

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