# Rowid and Toad v10.6

**URL:** <https://forums.toadworld.com/t/rowid-and-toad-v10-6/10168>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 21, 2011, 10:42am UTC](https://forums.toadworld.com/t/rowid-and-toad-v10-6/10168 "2011-01-21T10:42:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [January 21, 2011, 10:42am UTC](https://forums.toadworld.com/t/rowid-and-toad-v10-6/10168/1 "2011-01-21T10:42:09Z")

</div>

I am just trying to query the database using the rowid and Toad is throwing me out of the application. I’ve tried two different tables on two completely different databases. Any ideas?

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 21, 2011, 11:22am UTC](https://forums.toadworld.com/t/rowid-and-toad-v10-6/10168/2 "2011-01-21T11:22:42Z")

</div>

Is the table and external table – if so there are no row ids

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 21, 2011, 11:32am UTC](https://forums.toadworld.com/t/rowid-and-toad-v10-6/10168/3 "2011-01-21T11:32:22Z")

</div>

What do you mean exactly by ‘throwing me out of the application’?  
Toad is crashing? Something else?

I just tried this query and it worked OK

select t. rowid as row\_id , t. \*

from test\_table t

where rowid = ‘AAAS8uAAEAAAAIzAAA’

The other thing to mention is that Toad will hide the ROWID by default if it is  
part of the result set. To make it show up, you can click the little column  
selector widget in the top left corner of the grid, or you can alias the column  
like I did in my query above.
