下载

3下载券

加入VIP
  • 专属下载特权
  • 现金文档折扣购买
  • VIP免费专区
  • 千万文档免费下载

上传资料

关闭

关闭

关闭

封号提示

内容

首页 《跟我学Java 26日通》第 1 天 Oracle基本命令与简单查询(笔记03)

《跟我学Java 26日通》第 1 天 Oracle基本命令与简单查询(笔记03).pdf

《跟我学Java 26日通》第 1 天 Oracle基本命令与…

bjchengzhimin
2009-10-21 0人阅读 举报 0 0 暂无简介

简介:本文档为《《跟我学Java 26日通》第 1 天 Oracle基本命令与简单查询(笔记03)pdf》,可适用于IT/计算机领域

SQLscotttigeremp()empEMPNOENAMEJOBMGRHIREDATESALCOMMEMPEMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNONUMBER()VARCHAR()VARCHAR()NUMBER()DATENUMBER(,)NUMBER(,)NUMBER()<pk><fk>DEPTNOSELECT*FROMempWHEREdeptno=CLERKOracleCLERKupperSELECTename,empno,deptnoFROMempWHEREjob=UPPER('clerk')commcomm>salSELECT*FROMempWHEREcomm>salSELECT*FROMempWHEREcomm>sal*MANAGERCLERKSELECT*FROMempWHERE(deptno=ANDjob='MANAGER')OR(deptno=ANDjob='CLERK')MANAGERCLERKSELECT*FROMempWHERE(deptno=ANDjob='MANAGER')OR(deptno=ANDjob='CLERK')OR(jobNOTIN('MANAGER','CLERK')ANDsal>=)CTOMempDISTINcommISNOTSELECTDISTINCTjobFRWHEREcommISNOTcommISORcomm<SELECT*FROMempWHEREcommISORcomm<LASTDAY()LASTDAY(hiredate)=hiredateSELECT*FROMempWHERELASTDAY(hiredate)=hiredateMONTHSBETWEE()SELECT*FROMempWHEREMONTHSBETWEEN(sysdate,hiredate)>initcap()SELECTINITCAP(ename)FROMemplength()SELECTenameFROMempWHERELENGTH(ename)=RNOTLIKESELECTenameFROMempWHEREenameNOTLIKE'R'substr()SELECTSUBSTR(ename,,)FROMempaAreplace()SELECTREPLACE(ename,'A','a')FROMempSELECTename,hiredateFROMempWHEREMONTHSBETWEEN(sysdate,hiredate)>ORDERBYSELECT*FROMempORDERBYhiredateSELECTename,job,salFROMempORDERBYjobDESC,saltochar()SELECTename,TOCHAR(hiredate,'yyyy')year,TOCHAR(hiredate,'mm')monFROMempORDERBYmon,yearROUND()SELECTename,ROUND(sal)FROMemptochar()SELECT*FROMempWHERETOCHAR(hiredate,'mm')==SELECTename,ROUND(SYSDATEhiredate)FROMempASELECT*FROMempWHEREenameLIKE'A'SELECTename,TRUNC(MONTHSBETWEEN(sysdate,hiredate))yearFROMempSELECTename,TRUNC(MONTHSBETWEEN(sysdate,hiredate))year,TRUNC(MOD(MONTHSBETWEEN(sysdate,hiredate),))monFROMempSELECTename,TRUNC(MONTHSBETWEEN(sysdate,hiredate))year,TRUNC(MOD(MONTHSBETWEEN(sysdate,hiredate),))mon,TRUNC(MOD(sysdatehiredate,))dayFROMemp

用户评价(0)

关闭

新课改视野下建构高中语文教学实验成果报告(32KB)

抱歉,积分不足下载失败,请稍后再试!

提示

试读已结束,如需要继续阅读或者下载,敬请购买!

文档小程序码

使用微信“扫一扫”扫码寻找文档

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/18

《跟我学Java 26日通》第 1 天 Oracle基本命令与简单查询(笔记03)

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利