Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Use SELECT Statement to Count the Number of Rows in Oracle?

If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following select statement returns the number of rows in the "department" table:

SQL> SELECT COUNT(*) FROM departments;

COUNT(*)

----------

27

So there are 27 rows in the "departments" table.

 162 views

More Questions for you: