RE: strange SQL with TOAD

Hey Ron!

My guess is that the Dev has "Show ROWID in data grids" checked in the TOAD options, probably in "Data Grids - Data" if your version of TOAD is recent.

Take care of them fine VMS boxes... :)

HTH! GL! Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> Sent: Tuesday, January 14, 2003 11:34 AM
> To: Multiple recipients of list ORACLE-L
> Subject: strange SQL with TOAD
>
>
> 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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).