oracle case statement

Use case when for string replacement Copy codeThe Code is as follows :/* Mysql> select * from sales; + ----- + ------------ + -------- + ------ + ------------ + | Num | name | winter | spring | summer | fall | category | + ----- + ------------ + -------- + ------ + ------------ + | 1 | Java | 1067 | 200 | 150 | 267 | Holiday | | 2 | C | 970 | 770 | 531 | 486 | sion | | 3 | JavaScript | 53 | 13 | 21 | 856 | Literary | | 4 | SQL | 782 | 357 | 168 | 250

In VFP, you can use SQL statements to manipulate tables, and you do not need to open the database when you use SQL statements to manipulate tables. This example describes the Select query statement (data retrieval), and the format of the SELECT statement refer to the Select SQL command or the SQL language tutorial. In the case of VFP: to locate and find the reco

10 cases of high-concurrency MySQLSQL statement optimization in the production environment: This case is a database optimization teaching case for the linux O M training of Old Boys. If any reposted, you must retain this copyright statement in your actual work, O M or DBA personnel 10 cases of high-concurrency MySQLS

In an IF condition statement, a logical condition can only have one, and if there are multiple conditions, it can be resolved using nested IF statements, but this method increases the complexity of the program and reduces the readability of the program. Using the switch Process Control statement can solve these problems perfectly, with the following basic structure: Switch

Case statements are used to implement multiple if. else, but the usage is somewhat different, people who have learned other languages know that the case to match the variables, if there is a matching successful words to execute the corresponding statement. The case statement

Table Creation Create Table 'lil '('Id' int (10) Not null auto_increment,'Name' char (20) default null,'Birthday' datetime default null,Primary Key ('id') engine = InnoDB default charset = utf8 Data insertion: Insert into Lee (name, birthday) values ('Sam ', '2017-01-01 '); Insert into Lee (name, birthday) values ('Lee ', '2017-01-01 '); Insert into Lee (name, birthday) values ('john', '2017-01-01 '); Use Case when

1, determine whether a number is in the one-way.#!/bin/Bashread-P"pls input a number:"N Case "$n" inch 1) Echo "variable is 1" ;; 2) Echo "variable is 2" ;; 3) Echo "variable is 3" ;; *) Echo "pls input a number between 1 and 3"exit;Esac2, multi-level if statement rewriting#!/bin/Bashread-P"pls input a number:"Nif[$n-eq1]; Then Echo "$n is a variable 1"

Ext.: http://blog.csdn.net/wchinaw/article/details/7325641The main idea of the following article is that: in a generic Android project, the R class constants are defined with final, but after ADT 14, if in the library project, it will not have the final keyword,It is estimated that in the new ADT, the resource file becomes a library ...,In the case of the switch statement, if you use R.id.xxx, you will be p

This article was reproduced from: http://c.biancheng.net/cpp/view/7006.htmlC Language Chinese network launched remedial classes, including "c language tutorial, C + + tutorial, algorithm/Data Structure Tutorial", all are one-to-one teaching: a one-to-one tutoring + one-to-one answer + assignment + Project Practice + permanent learning. QQ Online, respond at any time!Case ... Esac is similar to the switch ... case