Re: Question on PROC

From: Yves Noel <noel_at_omega.univ-lille1.fr>
Date: 12 Apr 1994 07:22:48 GMT
Message-ID: <2odi88$d4h_at_netserver.univ-lille1.fr>


In article <1994Apr11.191659.23563_at_venice.sedd.trw.com>, nachnani_at_venice.sedd.trw.com (Harish Nachnani) writes:
|>
|>I have program which uses dynamic sql method 4.
|>
|>IN informix esql I can use select *,ROWID from ........
|>
|>but oracle pro c rejects select *,ROWID from .......
|>
|>Any suggestions!
|>
|>thanks
|>
|>
|>
|>
 Try select table_name.*, ROWID from table_name;

-- 
Yves NOEL ______________________________________________ C.I.T.I. (batiment M4)
Database Administrator ________________ Universite des Sciences et Technologies
Email: Yves.Noel_at_univ-lille1.fr ________ 59655 Villeneuve d'Ascq Cedex - FRANCE
Voice: (33) 20.43.42.70 _________________________________ Fax: (33) 20.43.66.25
Received on Tue Apr 12 1994 - 09:22:48 CEST

Original text of this message