Re: Is it Possible to get number and names of tables/columns?

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:<uik5em25l4dg06_at_corp.supernews.com>...
> If you mean the total number of tables and columns
> and their names, then yes.
>
> Have fun. It should not be to difficult to figure out how.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Konrad Den Ende" <konrad_at_voxway.com> wrote in message
> news:agcvhs$ba5$1_at_news.gu.se...
> > Don't tell me how to - just if it's possible. It's more fun to
> > find out that by myself. One will learn better if forced to go
> > the hard way. I'd like merely to ensure myself that the thing
> > IS possible so i won't get frustrated and bold thereof :)
> >
> > --
> >
> > Vänligen
> > Konrad
> > -------------------------------------------------------

Konrad, if you had to ask to bein with then I would think a clue would be in order other than just 'yes you can get a list of the tables and columns in the database'.

Look into the Oracle rdbms dictionary. The Oracle version# Reference Manual provides information on the dictionary views.

HTH -- Mark D Powell -- Received on Tue Jul 09 2002 - 08:09:03 CDT