select rowid Oracle

Question

Im trying to display the rowid pseudocolumn, but something strange happened, This is my query

select rowid, rowid||'', rowid r from dual

output:

ROWID||''           R
AAAAECAABAAAAgiAAA  AAAAECAABAAAAgiAAA

So why cant display rowid without alias or not concatenated with something else ? Any explanation ? I used Toad and Oracle 10g.

Answer 1

This seems to be a Toad setting to hide the pseudocolumn:

In your data grid, mouse-right-click - SELECT COLUMNS

Enable 'ROWID'

You also have -

Toad - View - Options - Data Grids - Data - Display - 'Show ROWID in editable grids'

It's displayed in SQL*Plus, SQL Developer, and other clients.