A project I've recently started working on is moving away from a legacy Oracle 9i database and I'm helping with the data migration to a new system. That means that I still have to go and poke around the 9i system from time to time. My usual experience has been with Oracle 10g and up so I was surprised when I tried to run 'desc table_name' to get the following error...
Luckily the data dictionary still exists and it is still possible to get a description of your table using a standard SQL statement. The following SQL will do the trick... (replace 'table_name'
with the actual name of your table).
A quick disclaimer...
Although I put in a great effort into researching all the topics I cover, mistakes can happen.
If you spot something out of place, please do let me know.
All content and opinions expressed on this Blog are my own and do not represent the opinions of my employer (Oracle).
Use of any information contained in this blog post/article is subject to this disclaimer
Other posts you may like...