Home » SQL & PL/SQL » SQL & PL/SQL » sql (Oracle)
sql [message #380932] Wed, 14 January 2009 03:09 Go to next message
tsvinayoracle
Messages: 3
Registered: January 2009
Location: India
Junior Member
how to see the no of rows in a table
Re: sql [message #380934 is a reply to message #380932] Wed, 14 January 2009 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
select count(*) from mytable;

Regards
Michel
Re: sql [message #380949 is a reply to message #380934] Wed, 14 January 2009 05:44 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
And as a second option:
analyze the schema and have a peek at the num_rows column in user_tables.

MHE
Re: sql [message #381296 is a reply to message #380949] Fri, 16 January 2009 03:34 Go to previous messageGo to next message
tsvinayoracle
Messages: 3
Registered: January 2009
Location: India
Junior Member
Hi thank you for your reply
if i see in the user_tables's num_rows for some tables its showing the no of rows and for some tables its not showing the no of rows can u tell me why?
Re: sql [message #381299 is a reply to message #381296] Fri, 16 January 2009 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Carefully read Maaher's post.

Regards
Michel
Re: sql [message #381305 is a reply to message #381299] Fri, 16 January 2009 04:11 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I agree; the answer is under his, khm, middle finger /forum/fa/1986/0/
Re: sql [message #381310 is a reply to message #381305] Fri, 16 January 2009 04:50 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Littlefoot wrote on Fri, 16 January 2009 11:11
I agree; the answer is under his, khm, middle finger /forum/fa/1986/0/

Embarassed Perhaps I'd better change my avatar...

MHE
Re: sql [message #381349 is a reply to message #380932] Fri, 16 January 2009 07:57 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
another option, possible the worst option is to do
select * from {table};
and just wait until it ends Wink

Reminds me of how Bob Ueker said how to catch a knuckleball. "Wait until it stops rolling and then pick it up."
Previous Topic: CAST VARRAY TO CURSOR
Next Topic: Determining which tables are external tables
Goto Forum:
  


Current Time: Sun Feb 09 09:55:14 CST 2025