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

843798
http://java.sun.com/products/plugin/

Jesper
843798
http://java.sun.com/products/plugin/

Jesper
843798
yes you need to have JRE installed, BUT even than, you may have problems to see an applet.

That is my case.
I have tryed installing many versions of JRE, and i cannot see applets.

Some i can see, and the vast majority i cant see!
I think the ones i can see are old applets that are compatible with MS JVM.

I have made some posts in the forums and no one is capable of giving me a solution.

Moreover, more friends of mine are having this problem. And more ppl in the forums are having this problem!

im geting frustrated!
1 - 3
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
21,807 views