Select rowid along with all other columns from a table in Oracle database
To select rowid along with all other columns from a table, just use an alias and get the columns using asterisk (*).
select rowid as id, mm.* from MOVIES_MASTER mm where MOVIE_ID = 98766;