COUNT Function Functionality

View All Public Scripts Login to Run Script

Script Name COUNT Function Functionality
Visibility Unlisted - anyone with the share link can access
Description Understanding the functionality of count function with NULL Rows.
Area SQL Analytics
Contributor Semi Fisnished Goods
Created Friday April 21, 2017

Statement 1

create table temp(sno number,Name VARCHAR2(10))

Table created.

Statement 2

insert all  
into temp values(1,'Santhosh') 
into temp values(2,NULL) 
into temp values(3,'Chris') 
into temp values(4,'Conor') 
into temp values(5,'TOM KYTE') 
into temp values(7,'Steven') 
select * from dual

6 row(s) inserted.

Statement 3
```
select count(*) from temp
```
```
COUNT(*)
6
```

COUNT(*)
6

Statement 4

select name from temp


NAME
Santhosh
 - 
Chris
Conor
TOM KYTE
Steven

6 rows selected.

NAME
Santhosh
-
Chris
Conor
TOM KYTE
Steven

Statement 5

select count(name) from temp


COUNT(NAME)
5

COUNT(NAME)
5

Statement 6

insert into temp values (NULL,NULL)

1 row(s) inserted.

Statement 7

insert into temp values (NULL,NULL)

1 row(s) inserted.

Statement 8

select * from temp


SNO NAME
 -  - 
1 Santhosh
2  - 
3 Chris
4 Conor
5 TOM KYTE
7 Steven
 -  - 

8 rows selected.

Statement 9
```
select count(*) from temp
```
```
COUNT(*)
8
```

SNO	NAME
-	-
1	Santhosh
2	-
3	Chris
4	Conor
5	TOM KYTE
7	Steven
-	-

COUNT(*)
8

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database