Optimized assignment

[DanielNN]

Look at what I found inside a package pa_hr_update_pa_entities of the Oracle Projects module;

Select all

... 
l_res_asgn_exists := 'N'; 
 
BEGIN 
SELECT 'Y' 
INTO   l_res_asgn_exists 
FROM   dual 
WHERE EXISTS (SELECT 'Y' 
              FROM   pa_resources_denorm 
              WHERE  person_id                     = l_person_id 
              AND    resource_effective_start_date = 
                                                 l_start_date_new); 
EXCEPTION WHEN NO_DATA_FOUND THEN 
  l_res_asgn_exists := 'N'; 
END; 
...

In addition to filling sausages unnecessarily in this artistic form,
even then, looking only at the result, it can still go wrong.
If any other exception be triggered from NO_DATA_FOUND Ferrou. :FOR.

[stcoutinho]

My God, Noctifero.

Hugs,

Sergio Coutinho

[dr_gori]

Remember when Microsoft programmers earned numbers of code lines.
That's why she had Easter Eggs everywhere.

CTRL SHIFT ALT BACSKPACE HOME -> shoots a tetris.

Heoheohe