2

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.

54l3d
  • 3,913
  • 4
  • 32
  • 58
  • 4
    I think it a TOAD internal processing issue. Try with simple SQLplus – Wernfried Domscheit May 06 '15 at 15:56
  • @Wernfried I dont have other query tool, but I tried with SQLFiddle.com and its worse, error message appear when querying `rowid`, if you are sure, plz try it with SQLplus and ill accept your answer. – 54l3d May 06 '15 at 16:23
  • SQL Developer can be a bit odd too - wraps the value to the length of alias (or 5 with no alias), without a column setting. SQL\*Plus is fine. – Alex Poole May 06 '15 at 16:43

1 Answers1

4

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.

Alex Poole
  • 183,384
  • 11
  • 179
  • 318
  • It might be also OCI related. There is an option where OCI implicitly returns ROWID as 0th column, even if the query does not return it. Maybe TOAD is somehow confused, when the query itself returns ROWID. – ibre5041 May 06 '15 at 18:15
  • @ibre5041 - I think the setting is to suppress display of that implicit OCI column; which is understandable but not helpful if you explicitly include it in your select list. – Alex Poole May 06 '15 at 18:18