nvl(expr1,expr2) if expr is null expr is the converted value. nvl(name,

What is the usage of NVL?

Question Posted / goutam

Answer Posted / goutam

nvl(expr1,expr2)
if expr is null
expr is the converted value.
nvl(name,'not known')
name is null
then it show not known

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Enlist some predefined exceptions?

1115

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1185

What is AUTH_ID and AUTH_USER in pl/sql ?

2237

What program will open a mdb file?

1020

what is a unique key ? : Sql dba

1151

Why do we use partitions in sql?

1096

How to move files from one directory to another in pl sql?

1254

What is the difference between a procedure and a function?

1216

Is nosql faster than sql?

1076

How do you copy a table in sql?

1111

what are set operators in sql? : Sql dba

1108

What is break?

1257

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1019

What is the most restrictive isolation level? : Transact sql

1128

Is trigger a stored procedure?

984