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