Datatype of ROWID in Oracle/SQL

sql oracle rowid
oneiros picture oneiros · Jul 23, 2012 · Viewed 31k times · Source

What is the data type of ROWID in Oracle/SQL? How is this value stored?

Answer

THE DOCTOR picture THE DOCTOR · Jul 23, 2012

The following link explains what the data type for ROWID is - ROWID data type

ROWID is stored as a psuedocolumn.

Related questions

Displaying RowID in Select * (all) Statement

I am trying to display the RowID alongside all columns from a Select * statement. I am using Oracle with Toad to run the SQL statement. I have two tables that I need to compare, but I do not have any …

Read More
HOW TO get records with given rowid list IN STRING from a table (Oracle)?

Any one can help me to resolve the FIXME ? -- Task: Get records with given rowid IN STRING from a table. -- NOTICE: I do not known where the given rowid comes from. -- OUTPUT 'AAAAB0AABAAAAOhAAA' SELECT ROWID FROM …

Read More
SQL to return the rownum of a specific row? (using Oracle db)

In Oracle 10g, I have this SQL: select dog.id as dogId from CANINES dog order by dog.codename asc which returns: id -- 204 203 206 923 I want to extend this query to determine the oracle rownum of a dog.id in …

Read More