Oracle: is ROWID a NUMBER or a VARCHAR?
In Oracle, i开发者_运维知识库s ROWID
a NUMBER
or a VARCHAR
?
Can any one help me out?
Neither. ROWID is a ROWID
:
- http://www.orafaq.com/wiki/ROWID
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.
精彩评论