| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: strange SQL with TOAD
Also, you might try turning off the 'editable queries' in the options. That
causes it to do a select rowid, * from table, so that once you edit the
grid, it will use the rowid to go back and actually make the update to the
data.
-----Original Message-----
Sent: Tuesday, January 14, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
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).
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: Nick Wagner
INET: Nick.Wagner_at_quest.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 - 12:35:46 CST
 |
 |