Re: A question about ROWID,Need Help!!
From: Kurian <kurian.kattukkaran_at_priority-health.com>
Date: Mon, 20 Jul 1998 15:18:31 -0400
Message-ID: <35B39807.52B5_at_priority-health.com>
Date: Mon, 20 Jul 1998 15:18:31 -0400
Message-ID: <35B39807.52B5_at_priority-health.com>
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.
Yes you CAN...
Use table alias to specify select list and wild char *
SELECT a.ROWID, a.* FROM TEMPTABLE
Hope you can do this...
Bye
Kurian
Received on Mon Jul 20 1998 - 21:18:31 CEST