是不是你们期末考试老师给的样卷啊..这么简单的.自己多想想吧 还有..那么多题..每道题给10分差不多,一共才10分,随便无聊写了点,剩下的自己补齐吧.一、 基础设置(18分)1、 创建新用户 oracle 密码oracle(3分)Create user oracle
应该是check()吧?而且是check in (条件)
我是用查询实现的select LTime from Loginlog where LId=( select max(LId) from Loginlog where LPerson=? and LId !=(select max(LId) from Loginlog where LPerson=?))
提示框可以在 plsql user interface恢复到缺省
create table my_emp as select * from emp;update my_emp set salary = salary+300 where empid in (select emp.id from emp, my_emp where emp.salaty=my_emp.salary and emp.name='scott')
只做了两个--根据输入指定员工的姓名,从emp表中查询该员工的--工资,并判断该员工的工资是否高于10000,--如高于10000,则给该员工的工资减少20%declarev_sal emp.sal%type;v_ename emp.ename%type:=upper('&v_ename');begin
select id, max(case when day = 1 then cost else 0 end) Monday, max(case when day = 2 then cost else 0 end) Tuesday, max(case when day = 3 then cost else 0
1.alter database add logfile group 4 '/oracle/oradata/orcl/redo04.log' size 50M;2.alter system sga_max_size=152M scope=both;3.alter system sga_target=152M scope=spfile;
select * from (select id,kc,grade,row_number() over(partition by kc order by grade desc) r1from leanr) twhere r1 <= 2; -------------------------------------你首先需要了解的是开窗函数 overover是指按照partition by 指定的字段分组,这里是按照kc分组,
declare q varchar2(1); s varchar2(400);begin select table_name into q from a where sno = --此处写你要查询的表的sno s := 'select * from '||q; execute immediate s; end;