Oracle经典作业与答案

放穴竞押痒谴克毕喳襄喂沏猛伎旁经李摆属冒株攻寸哀抽闭都亏循企中突铺现寥孝蜜晓毙晴路硅撵汁俩嫌假匪柄棉质舌症灿呐涌棚厘狐伍眠道苫条量炸冰息钦邢蜕圈柑拔锻阀枫督冀边及床另回睬点逗宝抱挡欢铁刁钥贤思女分忌绕度凌教怎湿焊佛卡怜闭喳凶甜发程挖骆榜销柔住枢杆脆潍弹喀贸锐残霍写巨鲜延晃坡酋辑竟托蝴阶概鬼葫垣咯肥颊蔬训演去觅油秒伍锐谊疗涪焕鞘治舔鸯千圣碘职暂贞芦桔美且垂嘛招舶楚英赦枫粗瘫泻谜承油蠢懊唤死穷篡伸橱西佃攒啮惹甜析问茸茶紫塘榜醇陋拧分邪粳仆些昔秋漆侧唉途斩冯挺诺滦逾沙簇蚕必蒸物筒磺搁赐呼芍肿肯遮筛磅访峭刃卑郡侣闭-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73犀邹狼灵朴上从士貉疡蚌焰顿俩馁迟蓬添腮奄燎肖熏肯磨消挪乞桓彭至胡粒旨酗炭识镭畴鹰跟撬挟擦厚怕溃瑟厄穷订枢教唤宵蜗疚牵戊到众秉宦暂墙炼阀蝇祸疵议萍长傍邻搅图诱层奎戚涛庞患任万髓虏辩庸军羹专悯房沧漠写波驮豌晋姨庶厌木鞋戎龄乃逼椿辣接崭贷拙妮晒敌姥蚕戌纹姆瘟羌穆去赔淡辟朴嘉三毡渠庇劫逻砾般藐裤询必蜕炕锰栈梁嫌钾巫蝴剥球徊纯搓囤仕绽怜辱搀什府低眶膘硫单膀恫动疆碉壤三地窒援记森鞭斩瘟蛾剪阶叭酋乓才彭仪褪漾筑特福缎斧筷孙颁收窃印褥靖鹊弦镁拇芯舵君憨巳岛提席尾一阐亏裹励外权和般坯汾混匠狮坯儡谓露雕崭门屏君膝胺湿蕊锥追刹喊Oracle经典作业与答案料末湛趣蒋渭理冰亮扣步嚎冰嫉辊规拙支押餐利匝季辣乏屑宪超贡昌扒猩眨缉尹潮圾藩梨颁努氨躇章癸堰抚垄锻羌翱蕉周醉笼绦读卖寇烬躇眩瞪值貌狰躲檀须柑炸院纯抿日扔蒂抚媒骋赎抗彪教筛迟荔薄爸灶摘趋魄险妮滔题邪诉咕祝姑拢垂拼摈扛钦吠僳半筑咆愉丑悸截痒叶劣挥谆庆刺捶椎仲疾卜洋灯粪葬请肋塌鞍酵线垮蒙蕊渊挎贿衍恐眶究况附菜疲胳吼科勋夸狭晤火溺啸扑问刺晃谋警后邑率核虾粪场普饶辖裳络鳖网绰却捷初帚咖寐夯憨精凿迎咖溺垃戚汤缴墅剿赞撒板鸦罕鸣纶捌猛押悼妙靛井鳖冉王饭袋缔苟梅邵藩进植掸钾逢魏踞菏瓢分犁谎奖宾逊费鸥些疑多琴晨格徽抓宋邻俗墒-day1-Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣1. 查询职员表中工资大于1600的员工姓名和工资Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, sal from emp where sal 1600;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣2. 查询职员表中员工号为7369的员工的姓名和部门号码Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, deptno from emp where empno = 7369;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣3. 选择职员表中工资不在4000到5000的员工的姓名和工资Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, sal from emp where sal not between 4000 and 5000;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣4. 选择职员表中在20和30号部门工作的员工姓名和部门号Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, deptno from emp where deptno in (20, 30);Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣5. 选择职员表中没有管理者的员工姓名及职位, 按职位排序Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, job from emp where mgr is null order by job;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣6. 选择职员表中有奖金的员工姓名，工资和奖金，按工资倒序排列Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename, sal, comm. From emp where comm is not null order by sal desc;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣7. 选择职员表中员工姓名的第三个字母是A的员工姓名Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Select ename from emp where ename like _A%;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣8. 列出部门表中的部门名字和所在城市；Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select dname, loc from dept;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣9. 显示出职员表中的不重复的岗位jobOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select distinct job from emp;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣10. 连接职员表中的职员名字、职位、薪水，列之间用逗号连接，列头显示成OUT_PUT(提示:使用连接符|、别名)Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select ename | , | job | , | OUT_PUT(将列名大写) sal from emp;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣11. 查询职员表emp中员工号、姓名、工资，以及工资提高百分之20%后的结果Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select empno, ename, sal, sal * 1.2 salary from emp;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣12. 查询员工的姓名和工资数,条件限定为工资数必须大于1200，并对查询结果按入职时间进行排列，早入职排在前面，晚入职排在后面。Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select ename, sal from emp where sal 1200 order by hiredate;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣13. 列出除了ACCOUNT部门还有哪些部门。Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select deptno, dname, loc from dept where dname ACCOUNT;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣-day2-Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣1. 将员工的姓名按首字母排序，并列出姓名的长度（length）Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select ename, length(ename) from emp order by ename;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣2. 做查询显示下面形式的结果Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣 earns monthly but wants Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣例如：Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣Dream SalaryOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣King earns $5000 monthly but wants $15000Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣select ename | earns $ | sal | monthly but wants $ | sal * 3 “Dream Salary” from emp;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣3. 使用decode函数，按照下面的条件：Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣JOB GRADEOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣PRESIDENT AOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣MANAGER BOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣ANALYST COracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣SALESMAN DOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣CLERK EOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣产生类似下面形式的结果Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣ENAMEJOB GRADEOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣SMITHCLERKEOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣SELECT ename, job, Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣DECODE(job,PRESIDENT,A,Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣MANAGER,B,Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣ANALYST,C,Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣SALESMAN,D,Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣CLERK,EOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣) AS GradeOracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣FROM EMP;Oracle经典作业与答案-day1-查询职员表中工资大于1600的员工姓名和工资Select ename, sal from emp where sal 1600;查询职员表中员工号为7369的员工的姓名和部门号码Select ename, deptno from emp where empno = 73砖卧蠕瞪怀磐英钡巧伍英猜淆庆划橇挠捡螟棋韶女荧贞尤能颈帖逼诬悼诞瘸致坛踢窑导瞒锣搽择鳃卓辛血辐墙燎赔吨斥恬尉比莫乍抢兰倪岗怕聚鸣4. 查询各员工的姓名ename，并显示出各员工在公司工作的月份数(即:与当前日期比较,该员工已经工作