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: Matthias Gresz <GreMa_at_t-online.de>
Date: 17 Jul 1998 07:25:48 GMT
Message-ID: <6omu9s$6q3$2@news02.btx.dtag.de>


Hi,

try:

select t.rowid, t.* from your_table t ;

violin schrieb:
>
> 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.

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\

Received on Fri Jul 17 1998 - 02:25:48 CDT

Original text of this message

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