Get the app
Referrals
Referrals
on
WigglyNoodle
WigglyNoodle
Oracle

Oracle PL SQL

Have 10+ yers of experience in data modelling , Performance Tuning, BRS , Management, module Development

15mo ago
Jobs
One interview, 1000+ job opportunities
Take a 10-min AI interview to qualify for numerous real jobs auto-matched to your profile 🔑
+322 new users this month
WigglyNoodle
WigglyNoodle
Oracle15mo

Nvl just replace null with value you given... however Coalesce will check the first occurrence of null value and replace with next value
Eg : Nvl(Emp_dob, '01-01-1990') if emp_dob is null it will just replace it with 01-01-1990

In coalesce(emp_dob,dob,'01-01-1990') if emp_dob is null then it will check dob and if that is also null then it will default it to 01-01-1990.

Hope this clears you the difference.

Discover more
Curated from across