Find Total Number of Records from a Table in Oracle

1. In Oracle, you can find the total number of records from a table via SQL. Login to the Oracle SQL and execute below command. As an example, you want to find the total records for table TSORA.

SQL> select COUNT(*) from SAPSR3.TSORA;

  COUNT(*)
----------
         3

2. You can confirm the number displayed is correct.

SQL> select * from SAPSR3.TSORA;
TABSPACE
--------------------------------------------------------------------------------
PSAPSR3
PSAPSR3640
PSAPSR3USR