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';
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment