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

Advertisements

28 thoughts on “Oracle COALESCE function

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

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

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

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

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

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

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

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

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

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

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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s