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: MarkP28665 <markp28665_at_aol.com>
Date: 17 Jul 1998 21:48:40 GMT
Message-ID: <1998071721484000.RAA18651@ladder03.news.aol.com>


violin.Hsiao_at_mail.pouchen.com.tw (violin) >> 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) <<

  1. Boy, are you lazy!
  2. Try select rowid, label.* from my_table label ....

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Fri Jul 17 1998 - 16:48:40 CDT

Original text of this message

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