Title:Check out the name of each employee, salary, department name, salary at the company level and the name of the leader, the salary of the leader, and the corresponding rank of the leaderThis is the EMP below the default Scott user of Oracle. A study questions between the Dept and the Salgrade table.Employee table (
Reading guide:
The software industry is in extreme shortage of talents, and the company is eager for help. The data shows that the average cycle of 1000 graduates from submitting resumes to obtaining offer is only 10 days, with an average of 5 companies interviewed per person.
The software industry salary is very attractive to college graduates. Data shows that of the 1000 graduates, the annual salary
: Tname is changedCreate or Replace Trigger TEA_TNAME_UPAfter--event is triggered beforeUpdate of Tname on teacher--action on the Tname column of the teacher table, or directly on the table, remove the row on the row directly on table--Do not write is statement-level, write for each row is row-levelBegin-what is triggered and doneSYS. Dbms_output. Put_Line (' tname is changed ');EndWhen updated: Update teacher Set tname = ' Pure rookie ' where tid=1;
return_expr2 whencomparison_exprn Then return_exprnELSE else_expr]
END
--Query the employee information for the department number 10,20,30, and if the department number is 10, print -1.1 times times its work, department 20th, 1.2 times times, 30th department, 1.3 times Times Select employee_id,last_name,department_id, case department_id when ten then salary*1.1 When salary*1.2 Else
then return_expr2When comparison_exprn then return_exprnELSE else_expr]
END
--Query the employee information for department number 10,20,30, and if the department number is 10, print--1.1 times times its work, department number 20th, 1.2 times times, 30th department, 1.3 times TimesSelect employee_id,last_name,department_id,Case DEPARTMENT_ID when ten then salary*1.1When salary*1.2else
Detailed entry-level prerequisites for Linux operations Engineers
|
Browse:659
|
Updated: 2013-12-24 23:23
|
Tags:linux
It automation operations is to be very convenient to use a variety of tools for management and maintenance, effective implementation of server protectionIntroduction to Linux OPS common tools
1. Many places often use the Rsync tool to impleme
in the requirements will be GA,PU,UV analysis of the operations department! All data mining positions are written in the requirements only hadoop,spark,etl of the work of the Data Warehouse! Other self-view, data mining has several kinds of positions: Advertising CTR estimate, machine learning, referral system, natural language processing and so on. Choose it yourself. Anyway, getting started can be a try. In short, the entry is easy to go into diff
Java entry-level books
After the project has been completed in the past few days, I have been idle. I want to write code and entertain myself. By the way, I want to study the background.Java Definition
① Object: an object is an instance of a class and has statuses and behaviors. For example, a dog is an object in the following states: color, name, breed, and behavior: tail shaking, calling, and eating.Class
5 obstacles that must be overcome by the beginner's entry-level program.
As an indispensable role in the Internet industry, programmers with high salaries and good employment have become two representative labels.
Many people have the idea of migrating data to or from the Internet as programmers. However, it is not easy to become a qualified Program. As a beginner, there are five obstacles that must be over
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.