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 188.8.131.52.0 - 64bit Production
PL/SQL Release 184.108.40.206.0 - Production
CORE 220.127.116.11.0 Production
TNS for HPUX: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production
Thanks in advance.
"Lo importante no es saber, sino tener el teléfono del que sabe." - Les Luthiers