Jujuxiaer的博客

创建表以及初始化数据：grant create table to sutdent1;-- Create table 学生信息create table HAND_STUDENT( STUDENT_NO VARCHAR2(10) not null, STUDENT_NAME VARCHAR2(20), STUDENT_AGE NUMBER(2), STUD...

子查询需求场景： 语法：select select_listfrom tablewhere expr operator (select select_list from table);举例：select last_name from employeeswhere salary > (sele...

非相关子查询当作一张表来用：select e.last_name,e.salary,e.department_id,b.salavgfrom employees e,(select department_id,avg(salary) salavg from employees group by department_...

一个来源插入多个目标表（无条件）:insert all into sal_history values(empid,hiredate,sal) into mgr_history values(empid,mgr,sal) select employee_id empid,hire_date hi redate,salary sal,manager_id mg...