Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

count all columns for tables owned by user

353673Jun 18 2009 — edited Jun 18 2009
I want to get a handle on the col width of ALL the tables owned by a user.
I have this syntax to check individual tables:
SELECT COUNT(*)
FROM user_tab_columns
WHERE table_name = <tbl_name>;

But, I did a DESC on the USER_TAB_COLUMNS and there isn't an owner\user that I can use to get all tbls.

Any suggestions how I can get this to go thru all the tables ( i'll spool the output to a file)
This post has been answered by 513949 on Jun 18 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2009
Added on Jun 18 2009
4 comments
714 views