To get list of name of tables in yoru database (as current user) run below script:
SELECT table_name
FROM user_tables
It will works if you have granted access to do that.
Useful resource for additional info can be found here:
http://stackoverflow.com/questions/205736/oracle-get-list-of-all-tables
DOMINIK SYMONOWICZ's blogs - FOREVER HUNGRY of knowledge, sarcasm, smiling, music, dancing, and food ...lots of food. This IT blog is a collection of notes with a simple solution with an explanation, added documentation, sarcastic comment and weird example. I also write about a lesson learnt from my mistakes. A non-it blog can be found here: Dominik Symonowicz's non-IT blog and website
No comments:
Post a Comment