Jul 13, 2006 #1 mlotfi Programmer Oct 14, 2003 26 US Hi, I am a newbie to oracle and databases, could you please show me how to select all tables of a database ? thank you
Hi, I am a newbie to oracle and databases, could you please show me how to select all tables of a database ? thank you
Jul 13, 2006 #2 KenCunningham Technical User Mar 20, 2001 8,475 GB Do you mean see the names of the tables? If so: select table_name from [dba][user][all]_tables (perhaps set pause on first). Choose whichever from dba, user and all. Is this what you require? Upvote 0 Downvote
Do you mean see the names of the tables? If so: select table_name from [dba][user][all]_tables (perhaps set pause on first). Choose whichever from dba, user and all. Is this what you require?