Oracle DECODE function with example | sql query with decode function | learn to code
learn to code
Example on Oracle DECODE function as alternative for case and if-then-else
Below queries I used in video:
select * from tb_user;
select first_name, rec_status from tb_user;
select first_name, rec_status, decode(rec_status, 'AC', 'Active', 'DL', 'Deleted', 'InActive') from tb_user;
On this page of the site you can watch the video online Oracle DECODE function with example | sql query with decode function | learn to code with a duration of hours minute second in good quality, which was uploaded by the user tech.prasadl 16 April 2021, share the link with friends and acquaintances, this video has already been watched 505 times on youtube and it was liked by 15 viewers. Enjoy your viewing!
