Home » SQL & PL/SQL » SQL & PL/SQL » SQL Count Statement
SQL Count Statement [message #20389] Mon, 20 May 2002 14:35 Go to next message
Xela
Messages: 3
Registered: May 2002
Junior Member
How can one get the count of the number of columns
(NULLs INCLUDED) from a table using SQL?

Thanx!

Report message to a moderator

Re: SQL Count Statement [message #20451 is a reply to message #20389] Sat, 25 May 2002 01:18 Go to previous message
K.senthilkumar
Messages: 6
Registered: May 2002
Junior Member
Hi
from user_tab_Columns you can get the
number of columns from a table.
Query is
--------
select count(column_name)
from user_Tab_columns

if you don't want null columns then
add in the where condition
where nullable='N'

if you want null columns then
add in the where condition
where nullable='Y'

Report message to a moderator

Previous Topic: Compilation based on dependency
Next Topic: associated variables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 10:20:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.