Decode cool ...

[Diego_Mello]

Galera ...

Have a look at this code ...

Select all

SELECT  
DECODE ( v_setor 
       ,'1' 
       ,DECODE(:b_controle.fil_filial, '16', 'MONT', '3', 'MONT', '30', 'MONT', 'MONT')  <--- este!     
       ,'2' 
       ,'PRE' 
       ,'3' 
       ,'BORD' 
       ,'4' 
       ,'ATEL.' 
       ,'5' 
       ,'COST' 
       ,'6' 
       ,'CORTE') 
    INTO v_setor 
FROM dual;

Did you see that interesting decode?

He checks .. if it is filial 16, it brings Mont ...
if it is of the subsidiary 3, it brings Mont ...
if it is of the subsidiary 30, Brings Mont ...
If it is not any of them ... Bring Mont !!!

Incredible !!!
EiHEHAEUAHEIUAHEIUA

[dr_gori]

hehehe ... show !! :-O

[rodcapella]

: -The: -O: -O

[RodrigoValentim]

Then deny complain that you get little ... I know you did not see!