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>
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