What is NVL() function?

What is NVL() function?

Oracle deals with Null values using NVL function. The function replaces the NULL value in the given column with the value provide to it. The function accepts two parameters, the first one is the column name and the second one is the value with which NULL has to be replaced.

Example :
Select Amount – NVL(Disc, 0) from Price
Oracle union, intersect and minus
Oracle union, intersect and minus - UNION: The UNION operator is used to combine the result-set of two or more SELECT statements Tables of both the select statement must have the same number of columns with similar data types. It eliminates duplicates.......
What is composite data type?
Collections are usually referred to as Composite Data types...
Types of composite data type
Following are the types of composite data types: RECORD – PL/SQL records are similar to C structures. A record provides with a way to deal with separate but related variables as a unit...
Post your comment
Discussion Board
about
Very helpful
shweta 04-16-2018

Related Content

Follow us

▲