/*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"*/>
