OraFAQ Forum: Server Administration » Re: how to count no. of rows in a table

Blog
Search
Help
Members
Register
Login
Home

Home » RDBMS Server » Server Administration » Re: how to count no. of rows in a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:26:08 CST 2024