Thanks, I'll play with that.
"GQ" <dbaguy_ott_at_yahoo.com> wrote in message
news:aad8b5cb.0408230705.2164b54a_at_posting.google.com...
> You can start out with something like the following - select * from
> dict where table_name like '%COLUMN%';
> Note that most views are available in three flavors (e.g. user_tables,
> all_tables, dba_tables).
> I'd recommend looking at User_tab_columns and user_constraints (where
> constraint_type='R').
> And if you are really lucky, you could try user_tab_comments and
> user_col_comments.
>
> GQ
>
> "Jeff" <idont_at_thinkso.com> wrote in message
news:<Pw7Wc.92$4o.40_at_fed1read01>...
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1093194494.325919_at_yasure...
> > >
> > > Query the data dictionary views. Run this query for a list of them.
> > >
> > > SELECT view_name
> > > FROM all_views
> > > WHERE view_name LIKE 'ALL%';
> > >
> > > But why connect to Oracle with MS Access? An overwhelming desire to
use
> > > the worst possible tool to do the job?
> >
> > HAHAHAHA. No, us low ranking po' folk in the military don't have Oracle
> > installed let alone get Oracle training, or ANY database training for
that
> > matter. All government desktop PCs come with Microsoft Access installed
and
> > I had to teach myself to use it. I have a couple of stand-alone
> > applications I have to use that connect to an Oracle database, but the
> > applications leave ALOT to be desired because I still have to build my
own
> > lists of data and compile statistics by hand over and over. If I can
> > connect to the Oracle database with Access and ADO, I can build my own
> > queries and reports once and be done with it at the click of a button
> > whenever it's needed. Whether or not Access and ADO are the worst
possible
> > tools, it's still a hell of alot faster than doing it by hand the way I
do
> > it now. The Oracle database I tried to connect to turned out to have
about
> > 2000 tables with a jillion fields. I need to figure out what the
> > relationships are before I can build my own queries.
> >
> > Jeff
Received on Mon Aug 23 2004 - 20:57:12 CDT
