Re: strange SQL with TOAD

At 10:34 AM 1/14/2003, Ron Rogers wrote:
>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?

The ROWID parameter is used by the Oracle ODBC driver (and I assume everyone else's ODBC & OLE DB drivers for Oracle) whenever the driver needs to provide functionality like scrolling a resultset (jump to row 1.000.000 without going through the other 999.999) or to update the data in the resultset. In these cases, the driver know that the ROWID will uniquely identify the row, so it just has to remember the set of ROWID's and it can call up any row. Similarly, if it needs to update a row, it can put a 'where ROWID=' clause in the update statement to ensure that only one row gets updated.

>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).

Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

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).