Sql

Search

oracle test if 0

-- Replace 0 values by a default value
SELECT nvl(NullIf(COL, 0), 99) FROM (SELECT 0 AS COL FROM DUAL);    -- 99
SELECT nvl(NullIf(COL, 0), 0) FROM (SELECT 500 AS COL FROM DUAL);   -- 500

Comment

PREVIOUS	NEXT

Code Example
Sql :: mamp mysql config file
Sql :: how do you execute the fragment or sqlBatch using scriptdom
Sql :: synapse sql table set pk
Sql :: To revoke create table from users
Sql :: how to add column with custom sequence in postgresql
Sql :: sql server query field names
Sql :: sql add multiple values
Sql :: how to run sql script in postgresql in windows
Sql :: nested query with all examples
Sql :: alembic upgrade show sql
Sql :: restore backup
Sql :: python sql last insertend
Sql :: sqlite3 not commit
Sql :: sql gap missing values
Sql :: unable to open database database.db file is encrypted or is not a database
Sql :: intellij idea add mysql connector
Sql :: rails sql query converstion
Sql :: Split Column with delimiter into multiple columns
Sql :: sql anywhere create procedure
Sql :: SQL Injection Using Always True Condition
Sql :: mysql clone table with data and add attribute
Sql :: != not working in mysql
Sql :: SOQL Parent to child
Sql :: how to fix mysql stop unexpectedly
Sql :: sqlserver: reverse like search
Sql :: sqlite escape single quote
Sql :: save_details_inrichting
Sql :: oracle table change tablespace lob column
Sql :: psql check table fields
Sql :: power bi dax add related shows column but not working

Search

SQL

oracle test if 0

ADD CONTENT