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

+1 Q:

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

+7 A:

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

OMG Ponies 2010-08-17 16:01:32

This leads to my next question at http://stackoverflow.com/questions/3504521/what-java-data-type-corresponds-to-the-oracle-sql-data-type-numeric.

Derek Mahar 2010-08-17 16:06:02

@Derek Mahar: Somehow, I knew that was the ultimate question... :)

OMG Ponies 2010-08-17 16:09:01

@OMG: So you may get rep for two answers for the price of one ultimate question!

Derek Mahar 2010-08-17 16:15:01

@Derek Mahar: Nah, I was close - it's been over a year since I worked with Java/Oracle, and I don't have my source handy to check.

OMG Ponies 2010-08-17 16:18:02

@OMG, Just FYI, Oracle does have an INTEGER datatype. It's internally implemented as a NUMBER, but the type exists.

DCookie 2010-08-17 16:22:48

@DCookie: Thx, yeah - knew that Oracle subtypes the data types but they're all NUMBER ultimately.

OMG Ponies 2010-08-17 16:24:58

ansaurus