Oracel empty string to 0, null to 0 processing method


Case study:

Select decode (columnname, value 1, translation value 1, value 2, translation value 2,… Value n, translation value n, default)

From talbename

Where …

practical application

decode(cxcygzcg, ”, 0, null, 0, cxcygzcg) cxcygzcg

Recommended Today

Review of SQL Sever basic command

catalogue preface Installation of virtual machine Commands and operations Basic command syntax Case sensitive SQL keyword and function name Column and Index Names alias Too long to see? Space Database connection Connection of SSMS Connection of command line Database operation establish delete constraint integrity constraint Common constraints NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY DEFAULT […]