Re: A question about ROWID,Need Help!!
From: SRINIVAS CHIKKA <SCHIKKA_at_worldnet.att.net>
Date: Wed, 22 Jul 1998 22:47:14 -0400
Message-ID: <6p6c1s$hnd_at_bgtnsc03.worldnet.att.net>
FROM table a;
Date: Wed, 22 Jul 1998 22:47:14 -0400
Message-ID: <6p6c1s$hnd_at_bgtnsc03.worldnet.att.net>
Use this :
SELECT a.*,
rowid
FROM table a;
Hope it helps,
Srinivas.Chikka.
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 Thu Jul 23 1998 - 04:47:14 CEST