oracle开发学习篇 替换变量
点击(此处)折叠或打开
-
替换变量
-
-
select ename,job,sal,hiredate
-
from emp
-
where sal>&inputsal;
-
-
select empno,ename,job,hiredate,sal
-
from emp
-
where ename=UPPER\'&inputename\';
-
-
select empno,ename,job,hiredate,sal
-
from emp
-
where ename like \'%&inputkeyword%\';
-
-
select empno,ename,job,hiredate,sal
-
from emp
-
where hiredate<TO_DATE(\'&inputhiredate\',\'yyyy-mm-dd\');
-
-
-
select empno,ename,job,hiredate,sal
-
from emp
-
where job=UPPER(&inputjob) and sal>&inputsal;
-
-
-
select &inputColumName from emp
-
where deptno = &inputdeptno;
-
-
select * from &inputetablename
-
-
select empno , ename , job , sal
-
from emp
-
where deptno = 20
-
order by &inputColumName desc
-
-
UNDEFINE inputgroupby;
-
set DEFINE OFF;
-
select &&inputgroupby,sum(sal),avg(sal)
-
from emp
-
group by &inputgroupby;
-
-
-
set DEFINE on;
-
DEFINE inputdname=\'ACCOUNTING\';
-
DEFINE inputdname;
-
SELECT * FROM dept
-
where dname = \'&inputdname\';
-
UNDEFINE inputdname;
-
-
-
UNDEFINE inputgroupby;
-
accept inputgroupby
-
prompt \'pelees enter groupby:\' format A10
-
SELECT &&inputgroupby,sum(sal),avg(sal) from emp
-
group by &inputgroupby;
-
-
-
accept inputDate DATE FORMAT \'YYYY-MM-DD\' prompt \'pelees enter time:\'
-
SELECT empno,ename,job,hiredate
-
from emp
- where hiredate=TO_DATE(\'&inputDate\',\'yyyy-mm-dd\');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29360162/viewspace-1433842/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle 开发学习篇 行列转换
下一篇：
没有了~
请登录后发表评论
登录
全部评论
