Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this
Sorry for having made myself misunderstood.
+ 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or
remove it.
A + 0 can do something when :
1) Put after the name of a number column, eg
WHERE SAL + 0 = 2000
2) And if there is an index on this
Mark Thank you very much for explanation. Now I understood the
case.+0 is nothing at statment.It is used only for Oracle does not
use theindex.Regards.Eriovaldo
- Mensagem Original De:
"Mark Richard" [EMAIL PROTECTED]Para: "Multiple
recipients of list ORACLE-L" [EMAIL
Stephane, Thank you very much for explanation.Now I
understood the case.+0 is nothing at statment.It is used only for
Oracle does not use de index.Very good.Best
Regards.Eriovaldo
- Mensagem Original De:
"Stephane Faroult" [EMAIL PROTECTED]Para: "Multiple
recipients of list
Dear Stephane,
At first, my apologize by the word Resource, it was the first word that I
found out and wrote it.
The case is that this command +0 , you can put it in the sentence line of
where and the sintaxe is correct.
Oracle executes the statment and don't gives error message.
My doubt is :
:
om.br Subject: Re: Resource for index
Sent
Friends
:I have a part of statment as below :
select column1 from table1where column1 = v_parameter;The
column1 is not indexed, so the table full scan will be
executed.Right?Well, I would like to know if anyone knows the
resource :select column1 from table1where
column1 = v_parameter+0What does
Friends :
I have a part of statment as below :
select column1 from table1
where column1 = v_parameter;
The column1 is not indexed, so the table full scan will be executed.
Right?
Well, I would like to know if anyone knows the resource :
select column1