Search code examples
oracle-databaseexporttoadrowid

Include ROWID in Dataset when Exporting from Toad

I am trying to export a dataset from Toad to Excel (or text delimited file). I need the ROWID to display in the resulting file.

I have "Show ROWID in editable grids" selected in View >> Toad Options >> Data Grids >> Data.

ROWID is being displayed in the Data tab of Schema Browser in Toad.

When I run Export Data from Schema Browser; under the Dataset tab the ROWID is being displayed in the SQL statement.

But when I export the dataset, I do not get the ROWID showing in the resulting (output) file.

I am running Toad 10.5.0.41.

Any advice on what I am missing?

Thanks in advance,

Marwan

Solution

  • Why don't you explicitly add ROWID to your SQL statement?

    select rowid, t.*
from my_table t;