Welcome to My Blog
Tuesday, December 29, 2009
To find the number of columns in a Table
select
count
(*)
from
all_tab_cols
where
table_name=
'student_master' and owner='school'
;
Also we can use,
select count(*) from cols where table_name='student_master';
Newer Posts
Home
Subscribe to:
Posts (Atom)