Hi Patrice,
I would describe it as casting not overloading. If a varchar2 column
contains a string representation of a number and its compared to a
number in a where clause then it will work.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com -
There is a seminar by Oracle re. these, search for Oracle Internals.
I highly recommend it along with the other ones in that series!!!
Patrice.
-Original Message-
Sent: Tuesday, September 09, 2003 7:00 PM
To: Multiple recipients of list ORACLE-L
where can i find a list of sqltrace
and = comparisons in SQL
There is a seminar by Oracle re. these, search for Oracle Internals.
I highly recommend it along with the other ones in that series!!!
Patrice.
-Original Message-
Sent: Tuesday, September 09, 2003 7:00 PM
To: Multiple recipients of list ORACLE-L
where
I don't know what to think re. this.
There is a view here that produces an error, I identified why -- in one AND
clause a number(9) datatype column is being joined with a varchar2(50)
datatype column.
The developer of this code says that this used to run, there must be
something wrong with the
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:overloading and = comparisons in SQL
I don't know what to think re. this.
There is a view here that produces an error, I identified why -- in one AND
clause a number(9
You can have in a where clause a varchar2 column compared to a number column
, if the varchar2 column only contains numeric then it will work.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
Hi!
Which kind of error? And where does it occur? What's the view code?
Oracle does an implicit datatype conversion (if possible) when comparing
different datatypes. Try to add the conversion explicitly with to_number for
example try then. Note that Oracle can't use indexes in joins for
It looks like it always converts a character column to a number (or date)
before comparing, never the other way around:
SQL create table a ( N1 number );
Table created.
SQL create table b (c1 varchar2(50));
Table created.
SQL insert into a values (1000);
1 row created.
SQL insert into a
where can i find a list of sqltrace events? seems that 10053 and 10046 are
well documented on hotsos. how many are there?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 5:39 PM
Hi!
Which kind of error? And where does
Boivin, Patrice J wrote:
I don't know what to think re. this.
There is a view here that produces an error, I identified why -- in one AND
clause a number(9) datatype column is being joined with a varchar2(50)
datatype column.
The developer of this code says that this used to run, there
Courtesy Julian Dyke ( http://www.juliandyke.com ):
SET SERVEROUTPUT ON
DECLARE
err_msg VARCHAR2(120);
BEGIN
dbms_output.enable (100);
FOR err_num IN 1..10999
LOOP
err_msg := SQLERRM (-err_num);
IF err_msg NOT LIKE '%Message
Wow.
Extremely simple and extremely nice :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 1:24 AM
Courtesy Julian Dyke ( http://www.juliandyke.com ):
SET SERVEROUTPUT ON
DECLARE
example try then. Note that Oracle can't use indexes in joins for
implicitly or explicitly converted data - unless you have relevand
function
based indexes there... So, you might have problem in your design.
Just a little clarification to my own post just in case:
The index can not be used
13 matches
Mail list logo