vincentdeelen

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;
  

vincentdeelen

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'

vincentdeelen

SELECT *
FROM   APEX_collections
WHERE  collection_name = 'MY_COLLECTION'

vincentdeelen

select 1
from   apex_collections
where  collection_name = 'MY_COLLECTION'
and    c0XX is not null 

vincentdeelen

EMPNO, ENAME, DEPTNO, DNAME
7369, SMITH, 20, RESEARCH
7499, ALLEN, 30, SALES

vincentdeelen

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
;

vincentdeelen

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 

vincentdeelen

select null
,      null
,      null
,      null
from   emp
union
select empno
,      ename
,      job
,      deptno

vincentdeelen

select empno
,      ename
,      job
,      deptno
from( 
   select null as empno
   ,      null as ename
   ,      null as job
   ,      null as deptno
   from   emp

vincentdeelen

$('#report_dept10 .uReportStandard tBody tr:not(:first)').each(
	function(){
         $(this).addClass( "emp ui-widget-content" );
         var idVal = $(this).find('td[headers="EMPNO"]').html();
         $(this).first('td').attr("id",idVal);
	}
)
$('#report_dept20 .uReportStandard tBody tr:not(:first)').each(
	function(){
         $(this).addClass( "emp ui-widget-content" );