Viraj Bandara Dodanwala 's Blog
Monday, August 23, 2010
How to get all the table names in oracle database
*) To get the Current User table names and the Details,
SELECT * FROM USER_TABLES;
*) To get All user Table names and the Details,
SELECT * FROM ALL_TABLES;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment