Re: A question about ROWID,Need Help!!

Kurian wrote:
>
> 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

OOPS i missed alias name in the example!!!!!

 SELECT a.ROWID, a.* FROM TEMPTABLE a Received on Mon Jul 20 1998 - 21:22:13 CEST