在Oracle數據庫中,可以使用以下幾種方法來查詢表中的行數:
SELECT COUNT(*) FROM table_name;
SELECT COUNT(1) FROM table_name;
ANALYZE TABLE table_name COMPUTE STATISTICS;
SELECT num_rows FROM user_tables WHERE table_name = 'table_name';
SELECT num_rows FROM dba_tables WHERE table_name = 'table_name';
SELECT table_name, num_rows FROM user_tab_statistics WHERE table_name = 'table_name';