Here you can find the source of NVL(String str, String replace)
Parameter | Description |
---|---|
String | value |
replace | with |
public static String NVL(String str, String replace)
//package com.java2s; //License from project: Apache License public class Main { /**/*w w w . j av a 2 s . c o m*/ * NVL - fix null value * @param String value * @param replace with * @return */ public static String NVL(String str, String replace) { if (str == null || str.trim().equals("") || str.trim().toUpperCase().equals("NULL")) return replace; return str; } /** * NVL - fix null value * @param string value * @return */ public static String NVL(String str) { return NVL(str, ""); } }