Re: Question: tables

From: <un2000_at_my-deja.com>
Date: Tue, 29 Jun 1999 21:50:08 GMT
Message-ID: <7lbf2c$sk5$1@nnrp1.deja.com>

select * from dba_tables where owner = '<owner>' and table_name = '<table_name>'; - should give you the tablespace, storage_clause etc. select* from dba_tab_columns were table_name = '<table_name>'; - should give you column and datatype information.

Hope this helps.

In article <37792401.9E88CE9C_at_cybertrails.com>, mark <mark_at_cybertrails.com> wrote:
> Im creating a temporary table that will be used for importing data to
> then updating the rest of the database off of the information in that
> table. However i don't know how some of the tables where created and
> what datatypes where used.
> Is there a way for me to see the setup of the table? like the column
> names and datatypes used??
>
> Any help is Apprciated!!!! Thanks
>
> Mark
> New DBA....
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 16:50:08 CDT