A Select overrides the other SELECT

[Hahu]

Glufke speaks,
Good morning everyone,
Today I'm again on customer XPto..rs!
I started working and I decided to post this code
These two SELECTS is inside a begin ....
See

Select all

 Select x.campo_tabela ||'/diretorioA' into diretorio  
                       from tabela x 
                     where x.data = (select max(y.data)  
                                               from tabela y  
                                             where   y.data < sysdate)  
and rownum =1; 
                          
Select x.campo_tabela into diretorio  
                       from tabela x 
                     where x.data = (select max(y.data)  
                                               from tabela y  
                                             where   y.data < sysdate)  
and rownum =1; 

DAEEEE Ends With the forth ..
Here is this code ..: LOL:

May God bless everyone!
abs hahu

[Toad]

Our!!!
And I delayed to understand what selected was not selector ...
: Wink:

[dr_gori]

Wow!
and I delayed to understand that selection was not selector ...

is right toad! I removed the "string" selected and changed to Select

[Toad]

Hahahahhaa !!! Now without the "string" gets clearer!
Thanks!
[color=# dcdcdc] and ... I think it had been purposeful !! [/color]