Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
List of "view" tables and List of Fields in a table
The following sql will give you all table_names and view names:<br> <br> select Owner, object_name, object_type<br> from all_objects<br> where object_type in ( 'TABLE','VIEW')<br> ;<br> <br> <br> <br> To list all fields and their attributes<br> from a specific table or view simple use<br> desc...
