rprt.net
当前位置:首页 >> 求高手回答OrAClE题。在线等。急急急!!!!!! >>

求高手回答OrAClE题。在线等。急急急!!!!!!

是不是你们期末考试老师给的样卷啊..这么简单的.自己多想想吧 还有..那么多题..每道题给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;

相关文档
zxsg.net | 9647.net | 90858.net | nczl.net | qwrx.net | 网站首页 | 网站地图
All rights reserved Powered by www.rprt.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com