Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: A question about ROWID,Need Help!!
select rowid, t.* from table t where ...
Andreas Prusch
In article <35aeb129.8769683_at_172.16.7.252>,
violin.Hsiao_at_mail.pouchen.com.tw (violin) wrote:
> Hello,I need some help!
> I want to select and update table by rowid.
> But if I want to get all columns ,
> I have to select rowid,column1,column2....columnN from table where...;
> Is there any easy way to get the rowid and all columns?
> ('Cause my table has 20 columns,and my SQL statement is so long..long)
> I'll very appreciate for your help.
> Please Cc to: violin_at_ms1.accmail.com.tw,Thank you.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 17 1998 - 01:26:32 CDT
![]() |
![]() |