Answers for "mysql equivalent decode oracle"

SQL
0

mysql equivalent decode oracle

create procedure ora_sp_decode2 (out job_level TEXT ) 
begin 
select CASE job_lvl
WHEN 1 THEN 'level 1
WHEN 2 THEN 'level 2'
ELSE 'Unknown level' end
into job_level from employee where job_id>0   ;
end ;
Posted by: Guest on February-11-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language