Viraj Bandara Dodanwala 's Blog: get al table names in oracle

Showing posts with label get al table names in oracle. Show all posts

Monday, August 23, 2010

*) 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;