This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select null | |
, null | |
, null | |
, null | |
from emp | |
union | |
select empno | |
, ename | |
, job | |
, deptno |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create or replace | |
trigger emp_dept_briu | |
instead of insert or update on emp_dept_v | |
referencing new as n | |
old as o | |
for each row | |
declare | |
l_deptno emp.deptno%type; | |
begin | |
case |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create or replace view emp_dept_v | |
as | |
select e.empno as empno | |
, e.ename as ename | |
, e.deptno as deptno | |
, d.dname as dname | |
from emp e | |
, dept d | |
where e.deptno = d.deptno | |
; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
EMPNO, ENAME, DEPTNO, DNAME | |
7369, SMITH, 20, RESEARCH | |
7499, ALLEN, 30, SALES |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select 1 | |
from apex_collections | |
where collection_name = 'MY_COLLECTION' | |
and c0XX is not null |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * | |
FROM APEX_collections | |
WHERE collection_name = 'MY_COLLECTION' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
begin | |
if apex_collection.collection_exists | |
( p_collection_name => 'MY_COLLECTION' ) | |
then | |
apex_collection.delete_collection | |
( p_collection_name => 'MY_COLLECTION' ); | |
end if; | |
apex_collection.create_collection_from_query | |
( p_collection_name => 'MY_COLLECTION' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
procedure set_column_headers | |
(p_table_name varchar2) | |
is | |
cursor c_columns | |
is | |
select column_name | |
from user_tab_columns | |
where table_name = upper(p_table_name) | |
order by column_id; | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
parent.closeIFrame() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function closeIFrame(){ | |
$('#parameterFrame').dialog("close") | |
} |