Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.oracletutorial.com › oracle-comparison-functions › oracle-decodeOracle DECODE Function - Oracle Tutorial

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

   • Zapisane w pamięci cache

   This tutorial shows you how to use the Oracle DECODE() function to add the procedural if-then-else logic to SQL queries.

   • Oracle COALESCE Function

     Introduction to the Oracle COALESCE() function. The Oracle...

2. www.techonthenet.com › oracle › functionsOracle / PLSQL: DECODE Function - TechOnTheNet

   www.techonthenet.com › oracle › functions

   This Oracle tutorial explains how to use the Oracle / PLSQL DECODE function with syntax and examples. The Oracle / PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement.

3. docs.oracle.com › en › databaseDECODE - Oracle Help Center

   docs.oracle.com › en › database

   • Zapisane w pamięci cache

   Purpose. DECODE compares expr to each search value one by one. If expr is equal to a search, then Oracle Database returns the corresponding result. If no match is found, then Oracle returns default. If default is omitted, then Oracle returns null.

4. www.databasestar.com › oracle-decode-functionOracle DECODE Function Explained with Examples - Database Star

   www.databasestar.com › oracle-decode-function

   • Zapisane w pamięci cache

   1 cze 2023 · The purpose of the Oracle DECODE function is to perform an IF-THEN-ELSE function. It’s similar to a CASE statement, but CASE is a statement where DECODE is a function. It allows you to provide a value, and then evaluate other values against it and show different results. It works similar to an IF statement within other languages. Syntax.

5. www.w3schools.blog › decode-function-oracleDECODE function in Oracle - W3schools

   www.w3schools.blog › decode-function-oracle

   • Zapisane w pamięci cache

   DECODE is an advanced function that the Oracle database supports. It is used to work as an IF-THEN-ELSE statement. The DECODE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

6. docs.oracle.com › cd › B19306_01DECODE - Oracle

   docs.oracle.com › cd › B19306_01

   • Zapisane w pamięci cache

   Purpose. DECODE compares expr to each search value one by one. If expr is equal to a search, then Oracle Database returns the corresponding result. If no match is found, then Oracle returns default. If default is omitted, then Oracle returns null.

7. www.datacamp.com › tutorial › sql-decodeUnderstanding the SQL DECODE() Function - DataCamp

   www.datacamp.com › tutorial › sql-decode

   • Zapisane w pamięci cache

   6 sie 2024 · Learn how to use DECODE() in Oracle for conditional logic in data transformation. Compare DECODE() to the CASE WHEN statement in performance and behavior.