RE: strange SQL with TOAD

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 14 Jan 2003 09:59:49 -0800
Message-ID: <F001.0052F60A.20030114095949@fatcity.com>

Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ??

-----Original Message-----
Sent: Tuesday, January 14, 2003 11:34 AM To: Multiple recipients of list ORACLE-L

List,
 We use TOAD as one of our database tools and I was viewing some of the SQL statements that were processed and I can't explain the "why" the statement is the way it is.
The developer wrote "Select to_char(sysdate,'mm-dd-yyyy') from dual;" in a VB application.

   We use the Oracle and MS ODBC drivers to connect to the database.   

What I saw as the SQL statement: "select ROWID,to_char(sysdate,'mm-dd-yyyy') from dual where ROWID = :v1" Where did the select ROWID come from?
In other statements where the select written is "Select table.* ..." I see "Select table.ROWID, table.*..." Again, where does the ROWID come from?
Is it a VB,/+ODBC thing that I should not be concerned with?

Any links to the info would be helpfull in understanding the query. Thanks,
Ron
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 14 2003 - 11:59:49 CST