crossbow exercise

Tags: define ACL command set override verify fine ROM BSPSelect Ename,column2 from Scott.emp; Input sal;/substitute scalar;SELECT * FROM tab;SELECT * from scott.emp where sal> sal; 2000SELECT * from Scott.emp where Ename=upper (' salary '); SCOTT;Define Col=commDefine viewing variablesSelect Ename,col from Scott.emp;Undefin col un-defined variablessal=sal is the equivalent of the Define command, the link is broken off.Set Verify off Check environment variable ~Oracle Variable

fromCoursewhereCNameinch('Mathematics','English') Step2SelectCid fromStudentwhereSsex='male'Step3SelectSid fromMarkwhereSidinch(STEP2) andCidinch(STEP1)Group bySid7. Find out the names of students who are evenly divided by more than the total sharing (sharing of all courses for all)Select avg from Selectfromgroupby hasavg(cmark)> (STEP1)8. Which course in Shanghai is evenly divided than FujianStep1SelectSid fromStudentwhereSnativeplace='Shanghai'Step2SelectCidavg(Cmark) fromMarkwhereSidin=(S

of the school number, name;Select S.id from student s where s.id not in (select S.id from student S, Teacher T, Course C, SC where sc.s_id=s.id an D sc.c_id=c.id and C.t_id=t.id and C.id =1)6. The inquiry has studied "001" and has also learned the number and name of the students in the "002" course;Select Aa.id,aa.sname from (select S.id,s.sname from student S, Teacher T, Course C, SC where Sc.s_id=s.id and Sc.c_id=c. ID and C.t_id=t.id and c.id =1) AA, (select S.id,s.sname from student S, Teac

department number and descending by salary:SELECTEmpno,deptno,sal,ename,job fromEmpORDER by 2 ASC,3 DESC; Replace letter stringSELECTTRANSLATE ('AB Hello BCADEFG','ABCDEFG','1234567') asNew_str fromDUAL; Sort alphabetically by letter and number in a mixed column data:6767adams→ename:adamsSELECTData,translate (data,'-0123456789','-') asEname fromVORDER by 2: First, the column of letters, that is, to take out the sort of the basis of another column ename, and then in the sort, the numbers an

Label:11. Check the average score of each course.12. Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.14. Sname, CNO and degree columns for all students are queried.15. Check the SNO, CNAME and degree columns of all students.16. Check the sname, CNAME and degree columns of all students.17. Check the average score of "95033" class students.19, the query elective "3-105" course performance is higher than the "109" student scores of all the

#!/bin/bashremote_ip=$1if[!-N" $"] ; Then Echo "Please usage./without_password remote_host!"Exit1Else Echo "The remote_host you input is $remote _ip"fiSSH[Email protected] $remote _IP"mkdir. ssh; chmod. SSH"Ssh-keygen-t RSASCP~/.SSH/id_rsa.pub [email protected]10.0.0.223:/root/.SSH/Authorized_keysSSH[Email protected]$1 "chmod ~/.ssh/authorized_keys"SSH[Email protected]$1ifconfigExit remote[[Email protected] ~]# exitlogoutconnection to10.0.0.223closed.eth0 Link encap:ethernet HWaddrxx: 0C:

Recently, I was going to review the shell, just to see the shell operation, and to write a simple 99 multiplication table like a beginner. It is suggested that you can run shell scripts directly in Http://www.runoob.com/try/runcode.php?filename=helloworldtype=bash if you do not want to install Linux environments.First, the previous code#!/bin/bash#使用while循环I=1;While [$i-le 9];d o #-le means less than or equal toJ=1;While [$j-le $i];d oEcho-n ${j} "x" $[i] "=" ' Expr $i \* $j ' ""; #echo-n means

ifMulti-branch statement practice#!/bin/bashread-p " Please enter 100 m running seconds: "IIf [$i-lt] [$i-GT 0]Thenecho " Enter the final "read-p " enter male and female "aif [$a = male]Thenecho " into the men's group "elif [$a = female]Thenecho " Enter the women's group "Elseecho "Error"Fielif [$i-ge 10]; Thenecho " elimination "Elseecho " Error "Fi Case Statement Practice, automatically unzip the compressed file according to the filename suffixVim untar.sh#!/bin/bashCase $ in*.gz)If [-F $]Th

/bakdir/root/dir1/dir3/file3-rw-r--r--1 root root 23M Feb 12 12:1 9/tmp/bakdir/root/dir1/file1-1-rwxr-xr-x 1 root root 3.7M Feb 12:19/tmp/bakdir/root/nginx-1.12.2/objs/ nginx-rw-r--r--1 root root 2.0M Feb 12:19/tmp/bakdir/root/pcre-8.40.tar.gz-rw-r--r--1 root root 1.2M Feb 12:19/t Mp/bakdir/root/pi. DAT 4.3 Concrete implementations[[emailprotected] ~]# cat CpFiles.sh #!/bin/bash#Func:cp files include directory#Author:reed. /etc/profileSourcePath="/root"DestPath="/tmp/BakDir"#mkdir backup direct

Exercise 1: Calculate the number of integers between 1 and 100;var sum = 0;for (var i =1; iSum+=i;}Console.log (SUM)Exercise 2: Require the user to enter a user name and password, as long as not admin, 888888 has been prompted the user name or password error, please re-enter.var name = +prompt ("Enter user name");var password = +prompt ("Enter password");while (name! = "Admin" password! = "888888") {Prompt

2 Practice 1 : Create a simple bank packagePractice target object-oriented encapsulation in-java language and the use of constructors.TaskIn this exercise, create a simple version of the account class. Place the source file into the banking package. In the default package for creating a single account, a test program testbanking has been written. This test program initializes the account balances and performs several simple things to handle. Finally,

Enjoy the health and happiness of barefoot jogging -- Write to you who want to exercise When you see barefoot customers, you may not be able to ask: Why do you want to run barefoot? Are you afraid of getting stuck? Won't it hurt when running? We step barefoot on the road that looks like we have feet, because of the pain, our feet will be light and light, lift up quickly and then fast, so to minimize the load on the knees, avoid sports injuries su

Continue with the study of the general graph, and draw a circular Chart here (Dount Chart). It is very simple, and the circle is covered with small circles. Haha, as shown in the following example: VcnPOiAgICAgICAgIDwvcD4KPHA + PHByZSBjbGFzcz0 = "brush: java;"> package com. xcl. chart;/*** Canvas exercise * Self-drawn circular Chart (Dount chart) ** author: xiongchuanliang * date: 2014-4-12 */import android. content. context; import android. graphics.

On Netease, data is cool >. It is also illustrated as follows: I didn't get much use of the api to draw this image, but I used some of the techniques I used to draw those images. The main program is as follows: Package com. xcl. chart;/*** Canvas exercise * Self-drawn circular Chart (Dount chart) * similar to the circular Chart in Netease's data cool * author: xiongchuanliang * date: 2014-4-12 */import android. annotation. suppressLint; impor

Label: style blog HTTP color Io OS AR for SP 1. exercise plan (exercise. Pas)Question The body is the capital of the revolution, and oiers should not neglect the health problem because of intense learning and waiting in front of the computer all day. Mr. X has designed his own exercise plan, but he does not know whether the plan is feasible. In other words, impro

51cto In the soft exam preparation season, the College specially sorted out "2014 soft exam programmers-frequent exam knowledge point review notes [summary]", to help schools pass smoothly! More Software proficiency test tutorials and questions, please pay attention to 51cto school-soft test classification ! Summary of exercise questions before the soft test programmer's test in 2014 1

51cto college specially sorted out "exercise questions and answers for the 2014 soft exam Network Administrator examination [summary]" in the soft exam preparation season to help schools pass smoothly! For more software proficiency test counseling and questions, please pay attention to the 51cto college-soft exam classification! Exercise questions and answers for the 2014 soft exam Network Adminis

Label: Health care This article is excerpted from the csdn Forum recommended by Mr. jiangtao: eye health guidance Myopia and myopiaIt's all about eye zoom. Eye Muscle stiffness involved in zoom. The following exercises can be performed: Help restore eye muscle Elasticity. (If you have no time, read the first section) 1. Practice (1) Remove glasses, Extend your arm, Shoulder level, with a fist held but a big finger erected, with a big fingertip to look out and select a target in the very dista

Exercise: E-commerce simple UML model I personally like to create a database after UML modeling. SQLSERVER is useless for some time. I would like to review the exercise code as follows: masterNOCOUNTON; dbo. sysdatabases) DatabaseOptimizationDatabaseOptimizationON (NAME, FILENAME, SIZE10, MAXSIZEUNLIMITE Exercise: E-commerce simple UML model I personally like to

COOKIES for PHP exercise project notes, and cookies for php exercises. COOKIES for PHP exercise project notes. php exercise cookies are mainly set when you log on and exit. To save logon and secure exit 1: On the logon page, set the cookie value for PHP exercise project notes, and set php