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 |
Post New Answer View All Answers
What are different types of tables in sql?
Is sql free?
Which join is like inner join?
What is user in sql?
Why are cursors used?
What are pl/sql cursors?
What does a pl/sql package consist of?
Which is better trigger or stored procedure?
What is using in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is attribute indicator in pl sql?
how to do backup entire database? : Transact sql
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
what is a constraint? Tell me about its various levels. : Sql dba
How do I remove sql plus from windows 10?