Home » RDBMS Server » Server Administration » Re: how to count no. of rows in a table
Re: how to count no. of rows in a table [message #373884] Wed, 16 May 2001 07:15
GIRIDHAR KODAKALLA
Messages: 92
Registered: May 2001
Member
In order to find out the number of columns in a table we can use the following query.

select count(*) from user_tab_columns where table_name = 'TEST';
(My table name is TEST).

Cheers.
Giridhar Kodakalla

Report message to a moderator

Previous Topic: MINUS function
Next Topic: Unsubscribe
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 25 12:08:24 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.