The COALESCE function returns first not null expression among the arguments. Minimum 2 arguments required.
If all expressions are null then it returns null.
Syntax:-
COALESCE (expr_1,expr_2,…expr_n)
Examples :-
1. select COALESCE(null,null,null,10) from dual;
would return 10.
2. select COALESCE(null,null,null) from dual;
would return null.
Related Posts
sqlandplsql.com - Learn SQL and DATABASES 
29 responses to “Oracle COALESCE function”
each time i used to read smaller posts which
as well clear their motive, and that is also happening with this article
which I am reading here.
Thanks for the comment!
Thanks for the comment!
Great Post
Thanks for the comment
Thanks for the comment
Appreciating the commitment you put into your site and in depth information you offer.
It’s good to come across a blog every once in a while that isn’t the same out of date rehashed information.
Great read! I’ve saved your site and I’m including your RSS feeds to my Google account.
Thanks for appreciation
Thanks for appreciation
I’m really inspired along with your writing talents as smartly as with the structure for your weblog. Is that this a paid subject matter or did you customize it your self? Either way keep up the excellent quality writing, it’s rare to
peer a great weblog like this one today..
Thanks for appreciation. Structure is free wordpress theme. Contents are my own.
Thanks for appreciation. Structure is free wordpress theme. Contents are my own.
What’s up to every body, it’s my first visit of this blog; this website consists of amazing
and genuinely fine information designed for readers.
Thank you.
Thank you.
Hi, i think that i saw you visited my website so i came to “return the favor”.
I’m attempting to find things to enhance my site!I suppose its ok to use a few of your ideas!!
Thanks
Thanks
Hello there folks, I am a zombie addict. I was discovering this post and I really appreciated it.
It has got many truly great insights for me to absorb.
I have got to mention, I have been lonesome in recent
months as my best mate isn’t here with me. Browsing websites gives me a bit of piece of mind . I’d love to thank you in this cool www blog post which will
can help pass the word involving zombies even more!
I really was wondering if you have rss opt-in list in order to routinely keep up-dated at this
website.
You actually make it seem so easy with your presentation but I
find this topic to be really something that I think I would never understand.
It seems too complicated and extremely broad for me.
I’m looking forward for your next post, I’ll try to get the hang of it!
After I originally left a comment I appear to have clicked on the -Notify me
when new comments are added- checkbox and now every time
a comment is added I recieve four emails with the exact same comment.
Is there a way you are able to remove me from that service?
Thank you!
I’ve been surfing online more than three hours today, yet I never found any interesting article like yours.
It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good
content as you did, the web will be much more useful than ever before.
Thanks for your appreciation
Thanks for your appreciation
I have been exploring for a little for any high-quality articles or weblog posts on this kind of area .
Exploring in Yahoo I ultimately stumbled upon this web
site. Studying this information So i’m happy to show that I have an incredibly excellent
uncanny feeling I discovered just what I needed. I most certainly will make sure to don?t
disregard this web site and give it a look regularly.
I love your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone
to do it for you? Plz answer back as I’m looking to construct my own blog and would like to know where u got this from.
thanks
Simply want to say your article is as amazing. The clarity in your post is just spectacular and i
could assume you are an expert on this subject. Fine with your permission
let me to grab your feed to keep up to date with forthcoming post.
Thanks a million and please continue the rewarding work.
Thanks for the comment
Thanks for the comment
I’m extremely impressed with your writing
skills as well as with the layout on your blog.
Is this a paid theme or did you customize it yourself?
Anyway keep up the nice quality writing, it’s rare to see a nice blog like this one nowadays.
Thanks!
Thanks!
My brother suggested I may like this website. He was once entirely right.
This publish actually made my day. You cann’t consider simply how
so much time I had spent for this information! Thank you!
Thanks
Thanks
Do you mind if I quote a few of your articles as long as I provide credit and sources back to your weblog?
My blog is in the exact same niche as yours and my visitors would definitely benefit from a lot
of the information you present here. Please let me know if this okay with you.
Regards!
Sure. Thanks
Sure. Thanks
I think this is among the most significant info for me.
And i’m glad reading your article. But should remark on some general
things, The web site style is great, the articles is
really excellent : D. Good job, cheers
Valuable info. Fortunate me I discovered your site unintentionally, and I am stunned why this accident did not came about earlier!
I bookmarked it.