EMAIL PROTECTED]>
> Subject: RE: overloading 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: Tuesd
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 even
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 - Orac
> 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 use
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
>
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 '||err_num||
"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 ru
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
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
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
implici
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
> My intuition says: NO.
Your intution loses. :)
drop table a;
drop table b;
create table a
as
select object_id, object_name
from dba_objects
where rownum < 11
/
create table b
as
select to_char(object_id) object_id_char, object_name
from a
/
alter table b modify(object_id_char varchar2(
12 matches
Mail list logo