Home » SQL & PL/SQL » SQL & PL/SQL » Re: SQL Count Statement
Re: SQL Count Statement [message #20395] Mon, 20 May 2002 15:19
Xela
Messages: 3
Registered: May 2002
Junior Member
Mahesh, thanx again! Brilliant idea you have here!!
* select column_name
from user_tab_cols
where table_name='EMP'

My only problem, for a lack of knowledge, is your SELECT clause, is "column_name" a SQL function or an argument?! I can see how SELECT COUNT is a function that will give me the result returned in the argument, but COLUMNS_NAME, I've never seen before?!

Thanx again!!

Report message to a moderator

Previous Topic: ORA-29850: invalid option for creation of domain indexes
Next Topic: Determining end of file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 20:16:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.