Wednesday, February 17, 2010

Oracle PL/SQL queries 2 - How to see list of tables in your database?

Since some programming languages' command for desc is !== database command for desc, you cannot use 'desc <table>' to see a database table's columns when coding.

Instead you should use, select * from user_tables;

If you need the column/size of a specific table:

select * from user_tab_columns where table_name = <table name>

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails