The best drill for learning about the database is the following:
SELECT VIEW_NAME
FROM DBA_VIEWS;
One day decide you are interested in tables. So do:
SELECT VIEW_NAME
FROM DBA_VIEWS
WHERE VIEW_NAME LIKE '%TAB%'
Describe the views. Query the views. Look at the results. Go to the documentation and find out what the columns mean. Then go read up on them. Ask questions on the forums about what you discovered. Pick one or two things a day that you want to explore. Start with tables, indexes, objects, and constraints. Then move on from there.
Spend 15-20 minutes a day doing this 5-6 days a week. After 6 months you will know more about the Oracle database than 95% of the people out there.
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Sep 18 2005 - 10:27:11 CDT
