Re: getting customer data in oracle 11i

nchopra_at_think3.com (Nik) wrote

> 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 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.

I'm guessing you want know:
- what tables are there?
- what columns do they have?

Oracle has a very rich data dictionary that contains all that and much more. To start you off, look at the view USER_TABLES (list of your tables) and USER_TAB_COLUMNS (list of columns in these tables).

If you are using SQL*Plus, you can use the SQL*Plus command called DESCRIBE. Have a look at the Oracle Concepts Manual, followed by the Oracle Reference Manual (one of the latter sections deals with user data dictionary views) and then the Oracle SQL Reference manual.

There are no shortcuts when it comes to doing things properly. Including in Oracle (which is why you elicit the responses to your posting that you did).

A bettter thing would be to go on formal Oracle courses to get a proper & correct intro do Oracle.

--
Billy