Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: A question about ROWID,Need Help!!
Hi,
try:
select t.rowid, t.* from your_table t ;
violin schrieb:
>
> 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.
--
Regards
Matthias Gresz :-)
GreMa_at_t-online.de
/| / | /| |\ /|| |\ / O |\ | |\ Galopping Horse beats Running Man. / |\ / / |\ / __/| |\ \° / | |\ \/_/ | |\Received on Fri Jul 17 1998 - 02:25:48 CDT
![]() |
![]() |