From: "Enzo Maini" <emaini@pcnet.com>
Subject: Re: simple question i'm sure, HELP!
Date: 1996/11/26
Message-ID: <01bbda8e$6d827ce0$67ead5cc@microndesktoppc>#1/1
references: <Pine.OSF.3.95.961123151900.28095C-100000@brain.uccs.edu>
organization: PCNet -- Connecticut's Internet Service Provider.
newsgroups: comp.databases.oracle



select * from user_tables.

if you need to see the structure of the table, type desc <table_name>.

select * from all_tables will give you access to all data dictionary views
you
have access to.

Kevin,
Could you answer a question for me.  What school are you attending that is
using
Developer/2000 and Oracle 7 in class?  Can you also tell me the class title
and
provide a course description.  The reason is because I own an Oracle
consulting
company and we are looking for Co-Ops for next year to intern as Assistant
DBAs,
Assistant Oracle Developers, and Jr. Software Engineers.

Enzo Maini
Owner - Lateral Thinking Software Systems, LLC
Trumbull, CT
enmaini@pcnet.com

KEVIN!!! <kdblakel@mail.uccs.edu> wrote in article
<Pine.OSF.3.95.961123151900.28095C-100000@brain.uccs.edu>...
> Ok, I am new to this database world and this is actually for a class
> project.  We are using Desinger 2000 and Oracle 7 at school and I would
> just like to know how through SQL Plus you can get a list of tables
 within
> your repository?  Any help would be great.....
> 
> Thanks
> Kevin
> 
> 
> 	
> 
> 		
>               
> 		
> 
>