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