How do you find the number of rows in a Table ?

Q

How do you find the number of rows in a Table ?

✍: Guest

A

select count(*) from table, or from NUM_ROWS column of user_tables if the table statistics has been collected.

2011-11-22, 2716👍, 0💬