Re: Anyone seen ROWID's added to the SELECT clause of a statement?
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: robertgfreeman@xxxxxxxxx
- Date: Fri, 16 Mar 2007 16:44:16 +0000
It's commonly used for 'scrollable' cursors with ADO (I think also
ADO.Netbut can't recall). It may be an artifact of the MS Oracle ODBC
driver from
memory.
see http://www.sqlteam.com/item.asp?ItemID=11842 for a sqlserver based
discussion of the options available.
On 3/16/07, Robert Freeman <robertgfreeman@xxxxxxxxx> wrote:
I have an application that everyone swears no changes
have occured on, that is adding a ROWID clause to the
end of the select clause of each SQL statement.
The application code does not appear to be doing this.
It runs through ODBC. The database does not appear to
be doing this.
Has anyone seen anything like this before?
Robert
Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)
Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts: