Re: getting customer data in oracle 11i

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Sat, 26 Jul 2003 01:52:00 +0200
Message-ID: <bfsfr0$v3o$1@svr8.m-online.net>

Nik schrieb:

> I am newbie to Oracle world, trying to get customer data like name, address,
> financial information etc. What tables should i be accessing/joining to get
> this kind of information.
>

I suggest you join the tables PERSON and ADDRESS and for sales information take the SALES table into your query.

> I looked around on the web for this info, unfortunately seems like very little
> information is available on this kind of problems. Any suggestions for books,
> other web sites would be appreciated.

*Any* SQL tutorial is the right start for you.

P.S.: you are joking, right? Received on Fri Jul 25 2003 - 18:52:00 CDT