Dynamic sql query
From: Prashant <khanna_prashant_at_rediffmail.com>
Date: 22 Jul 2003 06:59:47 -0700
Message-ID: <fc4206d.0307220559.24da7b31_at_posting.google.com>
Date: 22 Jul 2003 06:59:47 -0700
Message-ID: <fc4206d.0307220559.24da7b31_at_posting.google.com>
Hi Folks,
Can u help me out on a sql query:
Requirement is i need to print
table_name , columns_inside_table , rows_in_this_table of a particular
schema..
I have got 1 solution from using PLSQL , but i want to get the desired
output with sql qurey only.
I have partial solution of this:
"select table_name "Table Name" , count(*) "Columns" from
user_col_comments
/*((or v can also use user_tab_columns))*/ group by table_name;
This is giving me table_name and number of columns in this table but not rows..
Can U guys help me on it..
Thanx & regs in advance..
Prashant Khanna.
Received on Tue Jul 22 2003 - 15:59:47 CEST