全部博文
-
编辑 删除
oracle开发学习篇 替换变量
点击(此处)折叠或打开替换变量select ename,job,sal,hiredatefrom empwhere sal>&inputsal;select empno,ename,job,hiredate,salfrom empwhere ename=UPPER\'&inputename\';...
-
编辑 删除
Oracle 开发学习篇 行列转换
点击(此处)折叠或打开行列转换select deptno ,sum(decode (job, \'PRESIDENT \' ,sal,0)) PRESIDENT_job,sum(decode (job, \'MANAGER\' ,sal,0)) MANAGER_job,sum(decode (job, \'ANALYST\' ,sal,0)) ANALYST_job,sum(dec...
-
编辑 删除
oracle开发学习篇 可变数组
点击(此处)折叠或打开定义简单类型的可变数组; create or replace type project_varray AS VARRAY(3) OF varchar2(50);/drop table department purge;create table department( did &...
