Database MCQS - QUESTION DETAILS
What is the purpose of the Oracle NVL() function?
A. Concatenate multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows

'NVL()' is used to replace NULL values with a specified value in Oracle.

Similar Questions

What is the purpose of the Oracle TRUNCATE TABLE statement?





In MySQL, which type of index allows only unique values and nulls are considered distinct?





Which SQL function is used to find the length of a string?





What does T-SQL stand for in the context of SQL Server?





What is the purpose of the SQL Server LIMIT clause?





What is the purpose of the SQL Server CHARINDEX() function?





In SQL Server, what is the purpose of the TRIGGER?





In MySQL, what is the purpose of the IFNULL() function?





In MySQL, what is the purpose of the BLOB data type?





Which SQL Server statement is used to remove a user's privileges?