Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle nvl

-- force output for NOT NULL values
NVL(your_variable, Value_if_null)

-- OR (force outputs for both NOT NULL and NULL values)
NVL2(your_variable, value_if_not_null, value_if_null)
Comment

nvl in oracle

SELECT NVL(NULL, 'N/A') FROM dual;
Comment

oracle nvl2

NVL2( string_to_test, value_if_NOT_null, value_if_null )
Comment
PREVIOUS NEXT
Code Example
Sql :: counting in sql 
Sql :: rename column name sql server 
Sql :: createdb with postgresql on ubuntu 
Sql :: sql time format 
Sql :: postgres dump sql insert 
Sql :: sequence postgresql 
Sql :: replace divide by zero error with 0 in sql 
Sql :: SQL check if record exist 
Sql :: mysql order by date asc null last 
Sql :: sql max of two values 
Sql :: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint 
Sql :: restore backup mysql .gz 
Sql :: creating table in mysql 
Sql :: sql pass table name as variable 
Sql :: sqlite show columns 
Sql :: postgres default value 
Sql :: sql right join 
Sql :: multiple count with where clause sql 
Sql :: how to tun mysql on ubunto 
Sql :: add clumn to table postgres 
Sql :: power query add row 
Sql :: find log file postgresql linux 
Sql :: like in postgresql 
Sql :: between 
Sql :: oracle show errors 
Sql :: group by por mes sql mysql 
Sql :: change from not null postgresql 
Sql :: sql distinct clause 
Sql :: how to check user grant in mysql 
Sql :: list foreign key oracle 
ADD CONTENT
Topic
Content
Source link
Name
4+6 =