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.