Posted on Saturday, 20th June 2009 by captainmi2

Oracle SQL statement for counting the records in a table
For example:
Table A1 has 1000 records.
In SQL:

SQL> select count(1) as count_rec from A1;
count_rec
——–
1000

Tags:
Posted in Basic, Oracle | Comments (0)