Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle replace 0 values

SELECT IFNULL(Price, 0) FROM Products;
SELECT COALESCE(Price, 0) FROM Products;
-- Oracle (extra):
SELECT NVL(Price, 0) FROM Products;
 
PREVIOUS NEXT
Tagged: #oracle #replace #values
ADD COMMENT
Topic
Name
1+8 =