Yahoo Poland Wyszukiwanie w Internecie

Search results

1. 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. Syntax: DECODE( expression, search, result, search, result... , default ) Parameters:

   • To_Timestamp Function in Oracle

     TO_TIMESTAMP is one of the vital Conversion functions of...

   • CASE Function in Oracle

     CASE is an advanced function that the Oracle database...

2. www.w3schools.com › sqlSQL Tutorial - W3Schools

   www.w3schools.com › sql

   • Zapisane w pamięci cache

   SQL is a standard language for storing, manipulating and retrieving data in databases. Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Start learning SQL now »

3. www.sqltutorial.org › sql-comparison-functions › sql-decodeSQL DECODE - SQL Tutorial

   www.sqltutorial.org › sql-comparison-functions › sql-decode

   • Zapisane w pamięci cache

   The SQL DECODE () function allows you to add procedure if-then-else logic to queries. Let’s see the following example: SELECTDECODE(1,1,'Equal'); Code language:SQL (Structured Query Language)(sql) In this example, the DECODE () function compares the first argument (one) with the second argument (also one).

4. stackoverflow.com › questions › 1559241DECODE( ) function in SQL Server - Stack Overflow

   stackoverflow.com › questions › 1559241

   8 gru 2016 · create function decode(@var1 as bit, @var2 as nvarchar(100), @var3 as nvarchar(100)) returns nvarchar(100) begin return case when @var1 = 1 then @var2 else @var3 end; end; select dbo.decode(case when 10 > 1 then 1 else 0 end, 'Yes', 'No');

5. hightouch.com › sql-dictionary › sql-decodeSQL DECODE - Syntax, Use Cases, and Examples | Hightouch

   hightouch.com › sql-dictionary › sql-decode

   • Zapisane w pamięci cache

   Learn how to use the SQL DECODE function for conditional value replacement in Oracle Database and other systems. See the syntax, parameters, and examples of DECODE in SQL queries.

6. 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

   Oracle DECODE Function. Summary: in this tutorial, you will learn how to use the Oracle DECODE () function to embed if-then-else logic in SQL queries.

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.