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 :: sql query to select data between two dates 
Sql :: sql get character at index 
Sql :: sql update multiple columns 
Sql :: delete top 10 rows in sql 
Sql :: mysql biginteger size 
Sql :: rollback in sql 
Sql :: postgresql must appear in the GROUP BY clause or be used in an aggregate function 
Sql :: mysql disable logging 
Sql :: sql trim from string 
Sql :: create table from existing table in sql 
Sql :: oracle sql for each row 
Sql :: oracle parameter 
Sql :: how to tun mysql on ubunto 
Sql :: get duplicate entry sql 
Sql :: sql select from multiple tables without join 
Sql :: drop database using terminal postgres 
Sql :: declare or use variable in snowflake 
Sql :: sqlite alter table add multiple column 
Sql :: mysql get max value and id 
Sql :: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. 
Sql :: mysql in 
Sql :: split string by comma in sql server 
Sql :: sql insert into select 
Sql :: how to change server name in sql server 
Sql :: sql dcl 
Sql :: mysql two joins 
Sql :: oracle undo tablespace list by user 
Sql :: sql insert into 
Sql :: mysql delete older duplicates 
Sql :: SQL Primary Key multiple column 
ADD CONTENT
Topic
Content
Source link
Name
7+2 =