Question

oracle怎么查看一张表中有多少行记录？

Answer 1

select count(*) from tablename;
select count(1) from tablename;
select count(主键) from tablename ; 推荐这种写法。

Answer 2

select count(*) from table_name;

返回的值就是记录行数

Answer 3

select count(*) from your_table_name;
查看一张表中有多少行记录

Answer 4

select count(*) from table_name;
其中table_name为表名。