Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A question about ROWID,Need Help!!

Re: A question about ROWID,Need Help!!

From: <andreas.prusch_at_sintec.de>
Date: Fri, 17 Jul 1998 06:26:32 GMT
Message-ID: <6omqqo$tb8$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US