Re: EASY ???? Viewing table info from sqlplus .. HOW

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 16 Jun 1999 22:21:52 +0800
Message-ID: <3767B300.70AA_at_yahoo.com>


Clarence Hart Jr. wrote:
>
> Hello
> I'm sorry for asking such a simple Q but I dont know how to do this....
>
> Q.
>
> How do you view the info such as datatypes or defined views and stuff
> from sqlplus.
>
> ( In SYBASE its sp_help database or tablename)
>
> What is it in ORACLE?
>
> Thanks
>
> Clarence Hart
> clh_at_ismd.ups.com

See the other post for DESC command...

Also to get you started:

select * from user_tables
select * from user_indexes
select * from user_ind_columns
select * from user_tab_columns
select * from user_source
select * from user_synonyms
select * from user_sequences

etc etc

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."
Received on Wed Jun 16 1999 - 16:21:52 CEST

Original text of this message