Java Object NVL NVL(String source, String def)

Description

Implements Oracle style NVL function

License

Open Source License

Parameter

Parameter	Description
source	The source argument
def	The default value in case source is null or the length of the string is 0

Return

source if source is not null, otherwise return def

Declaration

public static final String NVL(String source, String def) 

Method Source Code

//package com.java2s;
/*/*from   ww w  .  jav  a 2  s  .c  o  m*/
 * This program is free software; you can redistribute it and/or modify it under the
 * terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software
 * Foundation.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
 * or from the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * Copyright (c) 2016 Pentaho Corporation..  All rights reserved.
 */

public class Main {
    /**
     * Implements Oracle style NVL function
     * 
     * @param source
     *          The source argument
     * @param def
     *          The default value in case source is null or the length of the string is 0
     * @return source if source is not null, otherwise return def
     */
    public static final String NVL(String source, String def) {
        if (source == null || source.length() == 0) {
            return def;
        }
        return source;
    }
}

Related

1. nvl(String pArg1, String pArg2)
2. nvl(String pValue)
3. nvl(String s)
4. nvl(String s, String def)
5. NVL(String s, String valorPorDefecto)
6. nvl(String source, String defaultString)
7. nvl(String str)
8. nvl(String str, String nullString)
9. NVL(String str, String replace)