XPost: comp.database.oracle, comp.databases.oracle.server   
   From: idont@thinkso.com   
      
   Thanks, I'll play with that.   
      
   "GQ"  wrote in message   
   news:aad8b5cb.0408230705.2164b54a@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"  wrote in message   
   news:...   
   > > "Daniel Morgan"  wrote in message   
   > > news:1093194494.325919@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)