LisaWimmer

Insert into pats.activity
  (SELECT *
     FROM pats.activity AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '20' MINUTE));


delete from pats.activity

LisaWimmer

begin
  sys.dbms_session.set_context(namespace => 'CLIENTCONTEXT',
                               attribute => 'CLIENT_USER',
                               value     => 'WIMMER');
end;

LisaWimmer

    raise_application_error(-20001, v('GLCAPT_SELECT_PARASITE'));
    
----------------------------------------------

apex_error.add_error(p_message          => 'Die Länge des Textblocks ist zu lange!',
                       p_display_location => apex_error.c_on_error_page, --apex_error.c_inline_with_field or apex_error.c_inline_with_field_and_notif
                       p_page_item_name   => 'P12_TEST');
                       
                       
  ------------------------------------------                     

LisaWimmer

  DECLARE
  name_is_already_used_955 exception;
  pragma exception_init(name_is_already_used_955,
                        -955);
BEGIN
  execute immediate 'CREATE UNIQUE INDEX PATS.Indexname ON Schema.Table (Col1, col2)';
EXCEPTION
  WHEN name_is_already_used_955 THEN
    NULL;

LisaWimmer

select ID,
        replace(replace(prompt,
                        '&',
                        ''),
                '.',
                '')
  from apex_220200.wwv_flow_step_items

-- update apex_220200.wwv_flow_step_items set Display_when = replace(display_when, '$$', '')
 where flow_ID = 707

LisaWimmer

declare

  l_JSON_New  clob;
  l_JSON_Old  clob;
  l_oldjobj   json_object_t;
  l_newjobj   json_object_t;
  l_keys      json_key_list;
  l_key       varchar2(4000);
  l_value_new varchar2(32000);
  l_value_old varchar2(32000);

LisaWimmer

select *
  from apex_220200.wwv_flow_step_items

-- update apex_220200.wwv_flow_step_items set Display_when = replace(display_when, '$$field_name', replace(NAME,'P301_',''))
 where flow_ID = 707
   and flow_step_id = 301
   and display_as != 'NAIVE_HIDDEN'

LisaWimmer

    apex_json.initialize_clob_output;
    apex_json.open_object;
  
    for cur in (select *
                  from PATS.is_department_species
                 where department_fk = p_dept_id)
    loop
      apex_json.open_array;
      apex_json.write('department_fk',
                      cur.department_fk);

LisaWimmer

select a
  from table t
  left join (select c001
               from apex_collections
              where collection_name = 'ENTRYSEARCH') c
    on (t.a = c.c001)
 where c.c001 is not null
    or (select count(*) cnt
          from apex_collections
         where collection_name = 'ENTRYSEARCH') = 0

LisaWimmer

declare
  i       pls_integer;
  l_query clob;
begin
  apex_session.create_session(p_app_id   => 777,
                              p_page_id  => 110,
                              p_username => 'QUATTRO_CR');
  i := quattro_lj.PCK_LJ_SEARCH.fillIDCollection('{
-- here should be a json file --
}