How to retrieve table schema in Oracle
I'd like to know which SQL command (if there is any) I can use to display the current schema of a table. I'm particular interested in knowing which columns are indexes.
My privileges to the DB are quite basic (I think that I'nm only allowed to run SELECT statements
This is the Oracle version that I'm using:
Oracle9i Enterprise Edition Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for HPUX: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
Thanks in advance.
"Lo importante no es saber, sino tener el teléfono del que sabe." - Les Luthiers