Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > Oracle DB 使用转换函数和条件表达式

Oracle DB 使用转换函数和条件表达式

WBOY
Release： 2016-06-07 17:32:27
Original
1089 people have browsed it

CASE表达式使你可以在SQL 语句中使用IF-THEN-ELSE逻辑，而无需调用任何过程。在简单的CASE表达式中，Oracle Server 会搜索其expr

以下代码是一个搜索CASE表达式示例。在搜索CASE表达式中，搜索从左到右进行，直到找到列出的条件，，然后它会返回相应的返回表达式。如果找不到满足的条件，但存在一个ELSE子句，则返回ELSE子句中的返回表达式，其它情况则返回NULL。

Related labels：
oracle
source：php.cn
Previous article：DB2数据库性能优化介绍 Next article：关于 Private strand flush not complete
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Why are my checkboxes still stuck and unable to return to their default values? I just created this function to change the page title after clicking the toggle button, bu...
From 2024-04-04 00:14:23
0
1
390
JQuery - On-the-fly calculations/conversions in dynamic tables I do have a dynamic HTML table (rows can be added) and I "just" want to read the...
From 2024-04-03 12:38:26
0
1
393
PHP question: Problem converting pdo column value to string Essentially, I'm using pdo to run the following query and format the results into JSON. Th...
From 2024-04-03 00:18:38
0
1
412
You cannot use the results of a function in other functions I have two functions convertToBase64(file) for converting the file addData(values) for sen...
From 2024-04-01 13:13:20
0
1
379
将How to retrieve and display JSON content in a WordPress function using PHP? I have a wordpress endpoint and I have some json data. Unfortunately I don't know how to r...
From 2024-03-30 17:42:32
0
1
346
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template