Quick Search:


	CODE Oracle PL/SQL Code Library


	FORUM Oracle Discussion & Chat

The Oracle COUNT Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: COUNT

Definition:
The Oracle COUNT function returns the number of rows returned by a query.

Example Syntax:



SELECT COUNT(sql expression)

FROM users

WHERE First_Name <> '';

For example, if you have the following table called users:

The result for the above query will return '3'.

Related Links:

Related Code Snippets:

Count Objects - This script: Echoes how many objects will be dropped by type. Type "enter" to co...
Number Functions: COUNT (running count) - Returns a running count of all records or by partition.
Number Functions: COUNT - Returns a frequency distribution.
REGR_COUNT - REGR_COUNT Returns the number of non-null numbers used to fit the regression line. ...
Count rows in all tables - Count the number of rows for ALL tables in current schema.
USERS: Lock and Unlock accounts - Oracle user accounts can be locked, unlocked, forced to choose n...
USER lock account - Lock or unlock the account on creation.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us