LL1x.com

-（高效） 0.187SELECT * FROM hr.employees emp --(基础表) WHERE emp.employee_id > 0 AND EXISTS (SELECT 'X' FROM hr.departments dept WHERE DEPT.Department_Id = EMP.Department...

游标游标分为显示游标和隐示游标。下面有两个实例然码实践这两个例子cursor c_name(var_name var_type)is|asselect ...from ...<--游标的语法->where...游标的属性：%isopen<--是否打开->%found%notfound%rowcount用法：open...

--触发器触发器:很耗性能有两个:old:newcreate or replace trigger t_emp_salary after update of salary on hr.employees for each rowdeclare -- local variables here name varchar2(60) ;begin...