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
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
as
--
-- 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
history
Version Date By Description
------- ----------- ---------------- ----------------------------------------------
0.1 22-FEB-2018 Dimitri First version, based on Dimitri's blog post
@dgielis
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
declare
l_clob clob;
l_body clob;
begin
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
loop
apex_json.initialize_clob_output;
@dgielis
dgielis / model_to_quicksql.sql
Last active Jun 13, 2019
Reverse engineer existing Oracle tables to Quick SQL
View model_to_quicksql.sql
declare
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);
begin
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
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
as
/**
* Constants
*/
c_from_email constant varchar2(100) := 'no-reply@my.email';
c_website constant varchar2(100) := 'my site';
c_hostname constant varchar2(100) := 'my hostname';
@dgielis
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
as
/**
* 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.