oracle & 的用法！

/*select * from emp_bak
where deptno = &"Department number"
order by ename;
select * from emp_bak
where deptno = &<name="Department number">
order by ename*/

select * FROM emp_bak e WHERE e.ename=&"a cc" ;
select * FROM emp_bak e WHERE e.ename=&"cc Varchar(10) ";


SELECT *
  FROM scott.emp
 WHERE DEPTNO = &< NAME = "DEPARTMENT NUMBER" HINT = "ONLY EMPLOYEES FROM THIS
 DEPARTMENT WILL BE LISTED" >
 ORDER BY ENAME;

SELECT *
  FROM EMP_BAK
 WHERE DEPTNO = &< NAME = "DEPARTMENT NUMBER" TYPE = "INTEGER" >
 ORDER BY ENAME


SELECT *
  FROM EMP_BAK
 WHERE ENAME = &< NAME = "Employee name" TYPE = "string" >
 
SELECT *
  FROM EMP_BAK
 WHERE DEPTNO = &< NAME = "Department number" REQUIRED = "yes" >
 ORDER BY ENAME

 select * from emp_bak
where deptno = &<name="Department number"
Default="10+20">
order by ename

 select * from emp_bak
where deptno = &<name="Department number"
Default="select deptno from emp_bak b where b.empno=7900">
order by ename


select * FROM Sys_Product s WHERE s.productcode=&<NAME="s.productCODE" DEFAULT=DEPT TYPE="STRING">;
select * FROM Sys_Product s WHERE s.productID=&<NAME="s.productID" DEFAULT=1 TYPE="INTEGER">;
SELECT * FROM SYS_PRODUCT S WHERE S.PRODUCTID &<NAME ="S.PRODUCTID NUMBER" LIST="1,2,3"  >

select * from scott.Emp where deptno = &<name="Department number" list="10, 20, 30, 40"> order by ename ;


SELECT *
  FROM SYS_PRODUCT S
 WHERE S.PRODUCTID = &< NAME = "s.productid number"
 LIST = "select productid , productcode from sys_product order by productid asc" >
 
 
 
SELECT *
  FROM SCOTT.EMP
 WHERE DEPTNO = &< NAME = "Department "
 LIST = "select deptno from scott.dept order by deptno"
 HINT = "请选择部门编号！" >
order by ename










select * from emp_bak
where deptno = &<name="Department number"
list="10, d,
20, a,
30, b,
40, c"
description="yes">
order by ename ;

/*要限定用户到列表中正确的项目，就要指定 restricted 选项
*/
SELECT *
  FROM EMP
 WHERE DEPTNO = &< NAME = "Department number"
 LIST = "select deptno, dname from dept order by dname"
 DESCRIPTION = "yes" RESTRICTED = "yes" >
 ----
 select * from emp
where deptno = &<name="Department number"
list="select deptno,dname from dept order by dname"
/*description="yes"*/>

 

转载于:https://www.cnblogs.com/linbo3168/p/6089336.html