› ›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Our Friends

Who's Online 0

Don't Hesitate for ask Question, post your assignment with hope you will find best solution.

What is the usage of NVL() function?

Virtual AssistantVirtual Assistant Posts: 24
in SQL

The NVL() function is used to convert NULL value to the other value. NVL() function is used in Oracle it is not in SQL and MySQL server.

Instead of NVL() function MySQL have IFNULL() and SQL Server have ISNULL() function.

Share on Facebook
Sign In or Register to comment.

ACC311 ACC501 ACC311  ACC501 ACF619  ACFI619 BIF401 BIF402 BIF501 BIF601 BIF602

BIF604 BIF619 BIF720 BIF731 BIF732 BIF733 BIT701 BIT703 BIT710 BIT715 BIO101 BIO102 

BIO201 BIO202 BIO203 BIO204 BIO301 BIO302 BIO303 BIO401 BIO502 BIO503 BIO601 BIO731 

BIO732 BIO733 BIO734 BNK601 BNK603 BNK604 BNK610 BNK612 BNK619 BNK620

BNK701 BNK703 BNK704 BNK725 BNKI619 BNKI620 BT101 BT102 BT201 BT301 BT302 BT401

BT402 BT403 BT404 BT405 BT406 BT503 BT504 BT505 BT601 BT603 BT605 BT619 BT720 BT731

BT732 BT733 BT734 BT735 BTI619

CS001 CS101 CS201 CS202 CS204 CS205 CS206 CS301 CS302 CS304 CS310 CS311 CS312 CS314 CS315 CS401

CS402 CS403 CS405 CS406 CS407 CS408 CS409 CS410 CS411 CS420 CS431 CS432 CS435 CS441 CS501 CS502 

CS504 CS506 CS507 CS508 CS510 CS519 CS601 CS602 CS603 CS604 CS605 CS606 CS607 CS608 CS609 CS610

CS611 CS614 CS615 CS619 CS620 CS625 CS701 CS702 CS703 CS704 CS706 CS707 CS708 CS709 CS710 

CS711 CS712 CS713 CS716 CS718CS720 CS721 CS723 CS724 CS726 CS799 COM619 COMI619