Re: SQL in Oracle

From: Lars Sjöström <lasse.sjostrom_at_telia.com>
Date: Fri, 08 Oct 1999 13:08:15 GMT
Message-ID: <31mL3.63$wp.170398208@newsa.telia.net>

I believe that Oracle 8 supports DROP COLUMN. Or it might be 8i.

If you are looking for different aspects of the dictionary you should investigate the view DICT, it has thw columns TABLE_NAME and COMMENTS. You can easily search that view for what you are looking for. In your case how ever you have to look at priviliegies, then you find the views (TABLE_NAME refers to table like objects I guess) mentioned in some of the answers below.

Lars Olof Sjöström
RKS Data AB
Linköping Received on Fri Oct 08 1999 - 08:08:15 CDT