Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help accessing attribute in method
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
![]() |
![]() |