Re: A question about ROWID,Need Help!!
From: Ulf Magnusson <ulf.magnusson_at_briunix.kiedt.ericsson.se>
Date: Fri, 17 Jul 1998 09:42:21 +0200
Message-ID: <6omupe$dcl_at_newstoo.ericsson.se>
Date: Fri, 17 Jul 1998 09:42:21 +0200
Message-ID: <6omupe$dcl_at_newstoo.ericsson.se>
Hello!
Try this
SELECT x.ROWID, x.* FROM emp x;
/Ulf
violin wrote in message <35b0ccc7.15840802_at_172.16.7.252>...
>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.
Received on Fri Jul 17 1998 - 09:42:21 CEST