Creating tables in oracle 8i

Creating tables in oracle 8i

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'ankur' on August 22, 2001 at 14:00:58 EST:

Hi folks!
This is my first experience with oracle. So i need a ton lot of assistance. I have three parameters account, devices and subscription services. I have to have a table of these 3 parameters. One account can have lots of devices attached to it and each device can subsribe for the same or different services. As for the queries, given an account name, i should be able to list the services associated with the account and the devices associated with the account. Given a device, i should be able to report the account in which it exists and the service it subscribes to. What all tables should i have and how i should create them. Please let me know.

Thanks in advance

Follow Ups:

Re: Creating tables in oracle 8i Amit Chauhan 16:10:10 8/22/01 EST (3)
- Re: Creating tables in oracle 8i SV 13:46:37 9/10/01 EST (0)
- Re: Creating tables in oracle 8i selvam 11:20:19 8/23/01 EST (1)
  - Re: Creating tables in oracle 8i amit_chauhan 20:34:37 8/23/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : Hi folks! : This is my first experience with oracle. So i need a ton lot of assistance. I have three parameters account, devices and subscription services. I have to have a table of these 3 parameters. One account can have lots of devices attached to it and each device can subsribe for the same or different services. As for the queries, given an account name, i should be able to list the services associated with the account and the devices associated with the account. Given a device, i should be able to report the account in which it exists and the service it subscribes to. What all tables should i have and how i should create them. Please let me know. : Thanks in advance