Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.oracletutorial.com › oracle-comparison-functions › oracle-nvlOracle NVL() Function By Practical Examples - Oracle Tutorial

   www.oracletutorial.com › oracle-comparison-functions › oracle-nvl

   • Zapisane w pamięci cache

   The Oracle NVL() function allows you to replace null with a more meaningful alternative in the results of a query. The following shows the syntax of the NVL() function: NVL(e1, e2) Code language: SQL (Structured Query Language) (sql) The NVL() function accepts two arguments. If e1 evaluates to null, then NVL() function returns e2.

2. docs.oracle.com › en › databaseNVL - Oracle Help Center

   docs.oracle.com › en › database

   Syntax. Description of the illustration nvl.eps. Purpose. NVL lets you replace null (returned as a blank) with a string in the results of a query. If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1. The arguments expr1 and expr2 can have any data type.

3. www.techonthenet.com › oracle › functionsOracle / PLSQL: NVL Function - TechOnTheNet

   www.techonthenet.com › oracle › functions

   The Oracle/PLSQL NVL function lets you substitute a value when a null value is encountered. Syntax. The syntax for the NVL function in Oracle/PLSQL is: NVL( string1, replace_with ) Parameters or Arguments. string1. The string to test for a null value. replace_with. The value returned if string1 is null. Returns.

4. docs.oracle.com › cd › B19306_01NVL - Oracle

   docs.oracle.com › cd › B19306_01

   • Zapisane w pamięci cache

   NVL lets you replace null (returned as a blank) with a string in the results of a query. If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1. The arguments expr1 and expr2 can have any datatype.

5. docs.oracle.com › en › databaseOracle Database SQL Language Reference, 19c - Oracle Help Center

   docs.oracle.com › en › database

   Primary Author: Usha Krishnamurthy. Contributors: Mary Beth Roeser, Drew Adams, Lance Ashdown, Vikas Arora, Thomas Baby, Hermann Baer, Yasin Baskan, Nigel Bayliss ...

6. ittalk.pl › funkcje-oracle-sql › funkcja-oracle-nvl-jak-obliczycFunkcja Oracle NVL. Jak obliczyć? - ITTalk.pl

   ittalk.pl › funkcje-oracle-sql › funkcja-oracle-nvl-jak-obliczyc

   • Zapisane w pamięci cache

   10 lut 2023 · Funkcja NVL (ang. Null Value) w języku SQL Oracle służy do zamiany wartości NULL na inne określone przez użytkownika. Składnia funkcji NVL wygląda następująco: NVL(wartość_porównywana, wartość_zamieniana) Przykład: SELECT NVL(NULL, 'brak danych') FROM dual; Wynik:

7. www.oracle-dba-online.com › sql › nvl-function-examples-oracleOracle Tutorial: NVL function explained with examples

   www.oracle-dba-online.com › sql › nvl-function-examples-oracle

   • Zapisane w pamięci cache

   The NVL() function has the following syntax. NVL(exp, replacement-value) Where the arguments are. exp: The expression which you want to evaluate and want to replace in case it is empty. replacement-value: The value which you want to return if the first argument is empty. NVL() Examples