Skip to content

Instantly share code, notes, and snippets.

Dimitri Gielis dgielis

Block or report user

Report or block dgielis

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
dgielis / app_error_pkg.sql
Created Jun 30, 2018
Custom Error Handling function for APEX
View app_error_pkg.sql
create or replace package app_error_pkg
-- Function: apex_error_handling
-- Purpose: Try to elegantly handle errors that occur while using the application.
function apex_error_handling (
p_error in apex_error.t_error )
return apex_error.t_error_result;
View ora_dev_cloud_pkg.sql
create or replace package ora_dev_cloud_pkg as
Purpose : Oracle Developer Cloud module
Version Date By Description
------- ----------- ---------------- ----------------------------------------------
0.1 22-FEB-2018 Dimitri First version, based on Dimitri's blog post
dgielis / oracle_apex_team_dev_2_bitbucket.sql
Last active Mar 13, 2018
Load Oracle APEX Team Development into Bitbucket issues
View oracle_apex_team_dev_2_bitbucket.sql
l_clob clob;
l_body clob;
for r in (select feature_name as title, '*'||focus_area||'*' ||feature_description || ' ' || publishable_description || '' as description
from apex_team_features
where nvl(feature_status,0) < 100 and nvl(focus_area,'A') <> 'ON HOLD')
-- change where to what you need
dgielis / model_to_quicksql.sql
Last active Jun 13, 2019
Reverse engineer existing Oracle tables to Quick SQL
View model_to_quicksql.sql
l_prefix varchar2(15) := 'EBA_DBTOOLS';
l_spaces varchar2(10) := ' '; -- use '&nbsp;' in web
l_enter varchar2(10) := CHR(10); -- use '<br/>' in web
l_constraint varchar2(500);
for t in (select t.table_name,
case when m.comments is not null then ' [' || replace(replace(replace(m.comments,'[','{'),']','}'),CHR(10)) ||']' end as comments
from user_tables t, user_tab_comments m,
(select max(lvl) as lvl, table_name
dgielis / mtl_auth_pkg.pkb
Last active Dec 27, 2017
Multiplication Table: Custom Authentication package body for Oracle APEX
View mtl_auth_pkg.pkb
create or replace package body mtl_auth_pkg
* Constants
c_from_email constant varchar2(100) := '';
c_website constant varchar2(100) := 'my site';
c_hostname constant varchar2(100) := 'my hostname';
dgielis / mtl_auth_pkg.pks
Created Aug 29, 2017
Multiplication Table: Custom Authentication package for Oracle APEX
View mtl_auth_pkg.pks
create or replace package mtl_auth_pkg
* Project: Multiplication Table
* Author: APEX RnD - Dimitri Gielis
* Description: Custom Authentication and Authorization
* Note: None
* @headcom
You can’t perform that action at this time.