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