Skip to content

Instantly share code, notes, and snippets.

View Dyoniso's full-sized avatar
🎯
Focusing

Pedro Santos Dyoniso

🎯
Focusing
View GitHub Profile
@Dyoniso
Dyoniso / SYS_GUID.sql
Created December 17, 2024 17:40
Oracle SYS_GUID
SELECT SYS_GUID() FROM DUAL
@Dyoniso
Dyoniso / blob-to-url.sql
Created May 27, 2024 18:46
Convert Blob to Url in APEX
-- Crie um AJAX CALLBACK COM O NOME GETIMAGE
DECLARE
l_export apex_data_export.t_export;
BEGIN
SELECT
ICON_FILE, ICON_FILENAME, ICON_MIMETYPE
INTO
l_export.content_blob, l_export.file_name, l_export.mime_type
@Dyoniso
Dyoniso / collection-with-file.sql
Created May 27, 2024 13:39
Cria uma collection e amarzena arquivos no APEX
DECLARE
v_filename varchar2(255);
v_mimetype varchar2(200);
v_blob_content blob;
BEGIN
-- LIMPA A COLLECTION PARA NOVOS DADOS
APEX_COLLECTION.TRUNCATE_COLLECTION(
@Dyoniso
Dyoniso / BUSCADOR_CEP.sql
Created May 3, 2024 20:13
Faz uma busca de cep de forma gratuíta em PL/SQL Oracle
-- Função para buscar CEP em PL/SQL
CREATE OR REPLACE FUNCTION GET_CEP (l_cep varchar2) RETURN clob IS
v_json clob;
BEGIN
v_json := apex_web_service.make_rest_request(
p_http_method => 'GET',
p_url => 'https://viacep.com.br/ws/' || l_cep || '/json/' );
@Dyoniso
Dyoniso / oauth2-client.sql
Last active March 7, 2024 12:12
ORDS OAUTH2 CLIENT CREATION
-- ORDS OAUTH2 CLIENT CREATION
DECLARE
v_client_name varchar2(255) := ''; -- NOME DO CLIENTE
v_client_priv varchar2(255) := ''; -- ORDS PRIV
v_client_role varchar2(255) := ''; -- ORDS ROLE
BEGIN
OAUTH.CREATE_CLIENT(
@Dyoniso
Dyoniso / change-dialog-title.js
Created November 24, 2023 19:16
Oracle Apex Change Dialog Title at runtime
apex.util.getTopApex().jQuery(".ui-dialog-content").dialog("option", "title", "Employee &P8_FIRST_NAME.");
@Dyoniso
Dyoniso / generate_random_key.sql
Created October 26, 2023 14:39
RANDOM PASSWORD KEY GENERATOR IN PLSQL
create or replace FUNCTION generate_random_key RETURN VARCHAR2 IS
v_key VARCHAR2(1000);
v_char VARCHAR2(1);
v_random_num NUMBER;
v_counter NUMBER := 0; -- Contador para adicionar traço a cada 4 caracteres
BEGIN
v_key := '';
FOR i IN 1..20 LOOP -- Largura da chave é 20 caracteres
-- Gera um número aleatório entre 1 e 36 (26 letras + 10 dígitos)
v_random_num := CEIL(DBMS_RANDOM.value(1, 36));