Oracle experiences 1 -- oracle introduction @ basic SQL statement @ conditional query @ sort data theory and case studies1. Oracle IntroductionOracle is the first word for English translation of oracle (Oracle bone inscriptions) Unearthed from Yin. Oracle is the world's largest supplier of information management software and services. It was founded in 1977 and is headquartered in Redwood shore, California.
Keyword: case
Case has two formats. Simple Case functions and Case search functions.
-- Simple Case Function
CASE sex
WHEN '1' THEN 'male'
WHEN '2' THEN 'female'
ELSE 'others' END
-- Case
Answer supplementYou can do this easily: Switch (a) {Case 0: Case 1: Case 2: printf ("lslksdjfl/N"); Case 3: Case 4: case 5: printf ("sdlfjsdlf/N"); default: printf ....}
Answer supplementCan you use the if
Case has two formats. Simple case functions and case search functions.1. Simple case Functions
Case sex when '1' then' male 'when' 2' then' female 'else' others' end
2. Case search functions
block is no longer executed.Case 3: try{} catch () {return;} finally{} return;The program executes the try first, and if an exception is encountered to execute a catch block,Exception: code that executes before return in a catch, including expression operations in a return statement,Then execute all the code in the finally statement, and finally execute the return in the Catch block,The return
You may be familiar with the IF Else statement, which is used to control the process. A CASE statement statement has a similar effect in the world of SQL. The following is a simple introduction to the use of case statements. Consider the following scenario, assuming that the
This is a creation in
Article, where the information may have evolved or changed.
Depending on the incoming condition, the SELECT statement executes a different statement. The following example prints a different content based on the input integer variable i:
Switch I {case 0: fmt. Printf ("0") Case 1:
Switch statements in PHP are used to perform different actions based on multiple different conditions. If you want to selectively execute one of several blocks of code, use a Switch statement.
Switch syntax
The code is as follows
Copy Code
switch (expression)//Set expression{Case Label1://Compare the value of label 1Code to is executed if expression = Label1; If matching the ou
MySQL can be used as an expression, or as a Process control statement in a stored procedure, as an expression:An If expressionIF(expr1,expr2,expr3)If Expr1 is true (expr1 Select*,if(sva=1,"male","female")as from where! = ""The IF as an expression can also be implemented with case:Select1' female 'END as fromwhere!=' In the return result of the first scenario, Value=compare-value. The return result of the second scenario is the real result of the
The Shell Case statement is a multi-select statement. A case statement can be used to match a value with a pattern, and if the match succeeds, the matching command is executed. The case statem
Oracle Decode () functions and case statements are all common use, so what is the difference between them? Here's a detailed description of
The difference between the Oracle Decode () function and the case statement for your reference.
First, give 2 simple examples to compare the differences between the 2.
1.CASE
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
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
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"
If the Case statement is not executed, let's see why .... -- Linux general technology-Linux programming and kernel information. The following is a detailed description. Today, I wrote a simple shell script to test the case statement and found a strange phenomenon. The procedure is as follows:
#! /Bin/sh
Echo 'hit a
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
Statement:Branching statements: if,if else,if ElseIf else,switch caseLooping statements: For,while,do While,foreachJump statement: Break,continueException statement: Try Catch finallyBranch statements:int a=5;if (a>0){Console.WriteLine ("This is a positive number");}Esle//If the a{Console.WriteLine ("This is a number less than or equal to 0");}else if (a>10){Console.WriteLine ("This is a number greater than
inflexible.Report Development Dimension ReferenceThe following dimensions borrow a report developed by Finereport to showDaily Money PlanDaily Funding Plan Dimension report development requires several key points to note:1. Date Lock2. column header pinning: Prevents too many column names, the item name cannot be found on display, and the header needs to be fixed to prevent too many project names from being found when the report is pulled down. 650) this.width=650; "src=" Http://s4.51cto.com/wy
change the color of a font with a case statement#!/bin/Bashcolor () {Red_color='\e[1;31m'Green_color='\e[1;32m'Yellow_color='\e[1;33m'Blue_color='\e[1;34m'Pink_color='\e[1;35m'RES='\e[0m'if[$#-ne2];then Echo"Usage $ content {Red|yellow|blue|green}"Exitfi Case " $" inchRed|RED) echo-E"${red_color}$1${res}" ;; Yellow|YELLOW) echo-E"${yellow_color}$1$
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.