Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to select rowid with select * from table_name

mlov83Feb 13 2012 — edited Feb 13 2012
Hello guys i have a cursor like so.
  Cursor c1 IS SELECT * FROM FZRASST;
  
    
  -- Row of type FZRASST row
  fzrasst_row c1%ROWTYPE;
when i try to reference the row id like this
fzrasst_row.rowid;
i get an error invalid indentifier? how can i reference the row id without implicitely selecting rowid? is this possible or do i need to change my select statement to select every column on the table?
Any help would be greatly appreciated.
This post has been answered by Solomon Yakobson on Feb 13 2012
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 12 2012
Added on Feb 13 2012
5 comments
20,965 views