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. stackoverflow.com › questions › 3804279Base64 encoding and decoding in oracle - Stack Overflow

   stackoverflow.com › questions › 3804279

   27 wrz 2010 · Solution with utl_encode.base64_encode and utl_encode.base64_decode have one limitation, they work only with strings up to 32,767 characters/bytes. In case you have to convert bigger strings you will face several obstacles.

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 · Table of Contents. Purpose of the Oracle DECODE Function. Syntax. DECODE Function Parameters. Oracle DECODE vs CASE. Oracle DECODE Function with NULL Values. Can You Use The Oracle DECODE Function In The WHERE Clause? Can You Use The Oracle DECODE Function With LIKE? Can You Use The Oracle DECODE Function With Greater Than?

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

6. 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 · This tutorial provides a comprehensive guide to using the SQL DECODE() function in Oracle. I will also compare DECODE() to CASE WHEN in Oracle and help you understand when to use each function. Finally, I will provide code for the equivalent transformations in SQL Server, PostgreSQL, and MySQL.

7. asktom.oracle.com › ords › fHow control file (SQL*LOADER) handle multiple ... - Oracle Ask...

   asktom.oracle.com › ords › f

   • Zapisane w pamięci cache

   19 gru 2023 · You can use a BFILE or even UTL_FILE (now that it supports seeking in a file) to read the first and last record of the file (seek to the end of the file and look "backwards" with dbms_lob.instr for the prior newline).