The decode () function is one of the powerful functions of ORACLEPLSQL. Currently, only oracle SQL provides this function, and other database vendors do not yet implement this function. The DECODE function is one of the powerful functions of
Functions in Oracle (1)-The Decode ecode () function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL provides this function, this function is not available for SQL implementations of other database vendors. The DECODE
In Oracle, the Decode () function is a powerful function in oracle pl/SQL. Currently, only oracle SQL provides this function, this function is not available for SQL implementations of other database vendors. The DECODE function is one of the
The decode () function is one of the most powerful functions of Oracle PL/SQL and is currently available only to Oracle Corporation, where SQL implementations of other database vendors do not yet have this function. The Decode function is one of
The decode () function is one of the powerful functions of Oracle Pl/sql, and it is currently available only in Oracle company SQL, and not in the SQL implementations of other database vendors.
The Decode function is an Oracle Pl/sql is one of the
Example of how to use the decode function in oracle, oracledecode
Decode usage
1: Use decode to determine whether the string is the same
DECODE (value, if1, then1, if2, then2, if3, then3,..., else)
Meaning:IF condition = value 1 THENRETURN (value 1)
Today, the above header requires a similar function, initially thought of column-to-row, but there is no good way to implement it, this function is good
The DECODE function is one of the powerful functions of oracle pl/SQL. Currently, only oracle
Today, the top request to do a similar function, the initial thought of column change, but how to achieve there is no good way, this function is good
The Decode function is an Oracle Pl/sql is one of the powerful functions, and currently only
Today, the above header requires a similar function, initially thought of column-to-row, but there is no good way to implement it, this function is goodThe DECODE function is one of the powerful functions of oracle pl/SQL. Currently, only oracle SQL
The decode () function is one of the most powerful functions of Oracle PL/SQL and is currently available only to Oracle Corporation, where SQL implementations of other database vendors do not yet have this function.Tools/Materials
•
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.