|
; Oracle Training; Oracle News; Oracle Forum; Class Catalog; Our Staff; Our Prices; Help Wanted! Remote DBA; Oracle Tuning; Emergency 911; RAC Support; Apps Support; ... In older versions of Oracle where the CASE is not available use DECODE instead: ... Here are some DECODE examples:
|
www.dba-oracle.com/t_decode.htm
www.dba-oracle.com/t_decode.htm
|
|
|
|
In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement. ... default is optional. If no matches are found, the decode will return default. If default is omitted, then the decode statement will return null (if no matches are found). ... Oracle 9i, Oracle 10g, Oracle 11g...
|
www.techonthenet.com/oracle/functions/decode.php
www.techonthenet.com/oracle/functions/decode.php
|
|
|
standard.decode( expr VARCHAR2 CHARACTER SET ANY_CS, pat VARCHAR2 CHARACTER SET expr%CHARSET, res VARCHAR2 CHARACTER SET ANY_CS); RETURN VARCHAR2 CHARACTER SET res%CHARSET; ... Decode Built-in Function ... Oracle DECODE & CASE Functions...
|
www.psoug.org/reference/decode_case.html
www.psoug.org/reference/decode_case.html
|
|
René Nyffenegger on Oracle - Most wanted - Feedback; ... decode compares expression to the search_x expressions and, if matches, returns result_x. If not, returns default, or, if default is left out, null.
|
www.adp-gmbh.ch/ora/sql/decode.html
www.adp-gmbh.ch/ora/sql/decode.html
|
|
The Oracle DECODE function provides similar functionality to an IF-THEN-ELSE statement. The general format for an Oracle DECODE function is: ... Anything you can do with an Oracle DECODE function, you could just as easily achieve with an IF-THEN-ELSE block. You would normally use a DECODE function over the IF-THEN-ELSE...
|
www.lattimore.id.au/2006/04/17/oracle-decode-function/t...
www.lattimore.id.au/2006/04/17/oracle-decode-function/trackback/
|
|
The most powerful of all of the BIFs are the decode and case functions. The decode and case functions are used within the Oracle database to transform data values for one value to another. ... Oracle started with the decode statement and later refined it in Oracle9i, morphing it into the case statement.
|
www.remote-dba.net/pl_sql/t_decode_case_sql_oracle.htm
www.remote-dba.net/pl_sql/t_decode_case_sql_oracle.htm
|
|
Comment on plperl RFC: (perl embedded in postgreSQL) An Oracle decode replacement ; Select or Download Code ... Re: plperl RFC: (perl embedded in postgreSQL) An Oracle decode replacement by zentara (Chancellor) on Jan 31, 2007 at 11:05 UTC...
|
www.perlmonks.org/?node_id=542185
|
|
i know for sure that the decode function and report in sql/pl is on the paper as has being each year. anyway i have looked at the sites u recommended and was wondering if there were any more examples that u could pass ... ; You are here: Experts > Computing/Technology > Oracle > Oracle > decode function in oralce sql/pl;
|
en.allexperts.com/q/Oracle-1451/decode-function-oralce-...
en.allexperts.com/q/Oracle-1451/decode-function-oralce-sql-1.htm
|
|
More Oracle Answers; Question Library; ... Ask a question about Oracle; Volunteer; Experts of the Month; Expert Login; Awards; About Us; Tell friends; Link to Us; Disclaimer; ... ; You are here: Experts > Computing/Technology > Oracle > Oracle > Decode (sql33+);
|
en.allexperts.com/q/Oracle-1451/2008/2/Decode-sql33.htm
en.allexperts.com/q/Oracle-1451/2008/2/Decode-sql33.htm
|
|
