Oracle COALESCE function

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

NVL
NULL
NVL2

29 responses to “Oracle COALESCE function”

  1. 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.

    1. Thanks for the comment!

  2. Thanks for the comment!

    1. Thanks for the comment

  3. Thanks for the comment

  4. 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.

    1. Thanks for appreciation

  5. Thanks for appreciation

  6. 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..

    1. Thanks for appreciation. Structure is free wordpress theme. Contents are my own.

  7. Thanks for appreciation. Structure is free wordpress theme. Contents are my own.

  8. 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.

  9. 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!!

  10. 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.

  11. 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!

  12. 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!

  13. 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.

    1. Thanks for your appreciation

  14. Thanks for your appreciation

  15. 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.

  16. 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

  17. 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.

    1. Thanks for the comment

  18. Thanks for the comment

  19. 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.

  20. 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!

  21. 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!

  22. 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

  23. Valuable info. Fortunate me I discovered your site unintentionally, and I am stunned why this accident did not came about earlier!
    I bookmarked it.