First you need to define your database as a SAS library, then you could use proc contents. You can learn how to define the library here:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_relationdb_6988.pdf
http://www.nesug.info/Proceedings/nesug05/io/io8.pdf
PROC CONTENTS does not show the number of observations, indexes, and creation and modification dates for tables in oracle databse.
I don't know how to get the details on indexes for tables in oracle database. Does anyone know?
-------
Message was edited by: Nilan
added 'tables in oracle databse' twice as my original message wasn't clear.