Oracle: is ROWID a NUMBER or a VARCHAR?

Question

In Oracle, is ROWID a NUMBER or a VARCHAR?

Can any one help me out?

Answer 1

Neither. ROWID is a ROWID:

• http://www.orafaq.com/wiki/ROWID

Answer 2

Technically, ROWID has its own datatype (also called ROWID or UROWID for IOTs). If you absolutely must use either NUMBER or VARCHAR datatypes, it will have to be a VARCHAR as the ROWIDs will contain more than just numbers.