APP TEST LOV

New

numérico

New

select FOS_EMP.EMPNO as EMPNO,
FOS_EMP.ENAME as ENAME ,
( select
display_value
from
apex_application_lov_entries
where
list_of_values_name = 'LOV_TEST_STATIC'
and return_value = DEPTNO
and application_id = :app_id
) DPTO
from FOS_EMP FOS_EMP

New

select FOS_EMP.EMPNO as EMPNO,
FOS_EMP.ENAME as ENAME ,
DEPTNO DPTO
from FOS_EMP FOS_EMP

New

Mgr	Hiredate	Sal	Empno	Ename	Job	Comm	Deptno
7566	03/12/81	3000	7902	FORD	ANALYST		20
7566	09/12/82	3000	7788	SCOTT	ANALYST		20
7698	28/09/81	1250	7654	MARTIN	SALESMAN	1400	30
7698	22/02/81	1250	7521	WARD	SALESMAN	500	30
7698	08/09/81	1500	7844	TURNER	SALESMAN	0	30
7698	20/02/81	1600	7499	ALLEN	SALESMAN	300	30
7698	03/12/81	950	7900	JAMES	CLERK		30
7782	23/01/82	1300	7934	MILLER	CLERK		10
7788	12/01/83	1100	7876	ADAMS	CLERK		20
7839	02/04/81	2975	7566	JONES	MANAGER		20
7839	09/06/81	2450	7782	CLARK	MANAGER		10
7839	01/05/81	2850	7698	BLAKE	MANAGER		30
7902	17/12/80	800	7369	SMITH	CLERK		20
	17/11/81	5000	7839	KING	PRESIDENT		10

1 - 14

Mgr	Hiredate	Sal	Empno	Ename	Job	Comm	Deptno
7566	03/12/81	3000	7902	FORD	ANALYST		20
7566	09/12/82	3000	7788	SCOTT	ANALYST		20
7698	28/09/81	1250	7654	MARTIN	SALESMAN	1400	30
7698	22/02/81	1250	7521	WARD	SALESMAN	500	30
7698	08/09/81	1500	7844	TURNER	SALESMAN	0	30
7698	20/02/81	1600	7499	ALLEN	SALESMAN	300	30
7698	03/12/81	950	7900	JAMES	CLERK		30
7782	23/01/82	1300	7934	MILLER	CLERK		10
7788	12/01/83	1100	7876	ADAMS	CLERK		20
7839	02/04/81	2975	7566	JONES	MANAGER		20
7839	09/06/81	2450	7782	CLARK	MANAGER		10
7839	01/05/81	2850	7698	BLAKE	MANAGER		30
7902	17/12/80	800	7369	SMITH	CLERK		20
	17/11/81	5000	7839	KING	PRESIDENT		10

1 - 14

Sal	Comm	Deptno	Empno	Ename	Job	Mgr	Hiredate
5000		10	7839	KING	PRESIDENT		17/11/81
2850		30	7698	BLAKE	MANAGER	7839	01/05/81
2450		10	7782	CLARK	MANAGER	7839	09/06/81
2975		20	7566	JONES	MANAGER	7839	02/04/81
3000		20	7788	SCOTT	ANALYST	7566	09/12/82
3000		20	7902	FORD	ANALYST	7566	03/12/81
800		20	7369	SMITH	CLERK	7902	17/12/80
1600	300	30	7499	ALLEN	SALESMAN	7698	20/02/81
1250	500	30	7521	WARD	SALESMAN	7698	22/02/81
1250	1400	30	7654	MARTIN	SALESMAN	7698	28/09/81
1500	0	30	7844	TURNER	SALESMAN	7698	08/09/81
1100		20	7876	ADAMS	CLERK	7788	12/01/83
950		30	7900	JAMES	CLERK	7698	03/12/81
1300		10	7934	MILLER	CLERK	7782	23/01/82

1 - 14

Empno	Ename	Job	Mgr	Hiredate	Sal	Comm	Deptno
7839	KING	PRESIDENT		17/11/81	5000		10
7698	BLAKE	MANAGER	7839	01/05/81	2850		30
7782	CLARK	MANAGER	7839	09/06/81	2450		10
7566	JONES	MANAGER	7839	02/04/81	2975		20
7788	SCOTT	ANALYST	7566	09/12/82	3000		20
7902	FORD	ANALYST	7566	03/12/81	3000		20
7369	SMITH	CLERK	7902	17/12/80	800		20
7499	ALLEN	SALESMAN	7698	20/02/81	1600	300	30
7521	WARD	SALESMAN	7698	22/02/81	1250	500	30
7654	MARTIN	SALESMAN	7698	28/09/81	1250	1400	30
7844	TURNER	SALESMAN	7698	08/09/81	1500	0	30
7876	ADAMS	CLERK	7788	12/01/83	1100		20
7900	JAMES	CLERK	7698	03/12/81	950		30
7934	MILLER	CLERK	7782	23/01/82	1300		10

1 - 14

New

teste campo numérico

TEST

New

New

New

New

Ações da Coluna

Ações da Coluna