What SQL data type does Oracle assign to "count(*)"?

sql oracle sqldatatypes
Derek Mahar picture Derek Mahar · Aug 17, 2010 · Viewed 10.8k times · Source

What SQL data type does Oracle assign to count(*) in a query like select count(*) from table? Does this depend on the count size?

Answer

OMG Ponies picture OMG Ponies · Aug 17, 2010

The value is an integer; Oracle only has a NUMBER data type.

Related questions

Is there any boolean type in Oracle databases?

Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server?

Read More
What does it mean when the size of a VARCHAR2 in Oracle is declared as 1 byte?

I know that I can declare a varchar2 using the number of the characters that it should be able to contain. However, in an Oracle database on which I am working, I found that a field (named PDF) is defined …

Read More
Workaround for ORA-00997: illegal use of LONG datatype

I want to save some data from a system table user_tab_cols, to a temp table so I can take a dump from it. There are 100,000 rows in it , I have select from user_tab_cols about 1,000 records and …

Read More