Search found 1976 matches

by admin
Thu Dec 30, 2021 6:30 am
Forum: Oracle APEX
Topic: APEX EMAIL Queue SQL
Replies: 0
Views: 162

APEX EMAIL Queue SQL

UTL_SMTP Email Procedure create or replace procedure html_email( p_to in varchar2, p_from in varchar2, p_subject in varchar2, p_text in varchar2 default null, p_html in varchar2 default null, p_smtp_hostname in varchar2, p_smtp_portnum in varchar2) is l_boundary varchar2(255) default 'a1b2c3d4e3f2g...
by admin
Thu Dec 30, 2021 2:39 am
Forum: Oracle APEX
Topic: Email from Oracle Autonomous Database Script
Replies: 0
Views: 73

Email from Oracle Autonomous Database Script

BEGIN APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'smtp.us-phoenix-1.oraclecloud.com'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_USERNAME', 'ocid1.user.oc1.username'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_PASSWORD', 'password'); APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_PORT',587); C...
by admin
Sun Dec 26, 2021 3:38 pm
Forum: Oracle APEX
Topic: Login Page Background and Logo Images
Replies: 0
Views: 83

Login Page Background and Logo Images

body{ background-image: url('#APP_FILES#technology.jpg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940'); background-position: center; background-repeat: no-repeat; background-size: cover; } .t-Login-logo { background-image: url('#APP_FILES#erpstuff logo.png'); background-repeat: no-repe...
by admin
Sat Dec 18, 2021 4:01 pm
Forum: Oracle APEX
Topic: Disable Format Header in TOAD
Replies: 0
Views: 162

Disable Format Header in TOAD

Whenever you format your code in TOAD a header line is displayed as below,
Format Header.png
If you want to disable it use the following option,
format header disable.png
by admin
Sat Dec 18, 2021 6:45 am
Forum: Oracle APEX
Topic: SQL Joins
Replies: 0
Views: 125

SQL Joins

select * from emp; select * from dept; select e.* from emp e inner join dept d on e.deptno = d.deptno select e.* from emp e left join dept d on e.deptno = d.deptno select e.* from emp e left outer join dept d on e.deptno = d.deptno select e.* from emp e right join dept d on e.deptno = d.deptno selec...
by admin
Sat Dec 18, 2021 6:41 am
Forum: Oracle APEX
Topic: EMP & DEPT Sample Tables Creation Script
Replies: 0
Views: 129

EMP & DEPT Sample Tables Creation Script

create table js_dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) ); / create table js_emp( empno number(4,0), ename varchar2(10), job varchar2(9), mgr number(4,0), hiredate date, sal number(7,2), comm number(7,2), deptno number(2,0), constraint...
by admin
Mon Dec 13, 2021 6:01 am
Forum: Oracle APEX
Topic: Flows for APEX DB Objects List
Replies: 0
Views: 119

Flows for APEX DB Objects List

select object_name, object_type from user_objects where object_name like 'FLOW_%' order by object_name, object_type; OBJECT_NAME OBJECT_TYPE FLOW_API_PKG PACKAGE FLOW_API_PKG PACKAGE BODY FLOW_BOUNDARY_EVENTS PACKAGE FLOW_BOUNDARY_EVENTS PACKAGE BODY FLOW_BPMN_PARSER_PKG PACKAGE FLOW_BPMN_PARSER_PKG...
by admin
Sun Dec 12, 2021 3:46 pm
Forum: Oracle APEX
Topic: APEX_DEBUG_MESSAGE
Replies: 0
Views: 120

APEX_DEBUG_MESSAGE

DECLARE l_value varchar2(100) := 'ERPstuff Error Message'; BEGIN APEX_DEBUG_MESSAGE.ENABLE_DEBUG_MESSAGES(p_level => 3); APEX_DEBUG_MESSAGE.LOG_MESSAGE( p_message => 'This is my message = ' || l_value, p_level => 1 ); APEX_DEBUG_MESSAGE.DISABLE_DEBUG_MESSAGES(); END; NOTE: Level or levels of messag...
by admin
Sun Dec 05, 2021 2:05 pm
Forum: Oracle APEX
Topic: Master Detail Report using XML Desktop Publisher
Replies: 0
Views: 235

Master Detail Report using XML Desktop Publisher

In this topic all scripts and details related to developing a master-detail report in Oracle APEX. Register free at https://apex.oracle.com/ PO Header Table CREATE TABLE "PO_HEADERS_ALL" ( "PO_HEADER_ID" NUMBER, "VENDOR_NAME" VARCHAR2(100), "VENDOR_SITE_NAME" ...
by admin
Fri Dec 03, 2021 4:12 pm
Forum: Oracle APEX
Topic: Data Export Function Sample PL_SQL
Replies: 0
Views: 117

Data Export Function Sample PL_SQL

DECLARE l_context apex_exec.t_context; l_export apex_data_export.t_export; BEGIN l_context := apex_exec.open_query_context( p_location => apex_exec.c_location_local_db, p_sql_query => 'select * from emp' ); l_export := apex_data_export.export ( p_context => l_context, p_format => apex_data_export.c_...
by admin
Mon Nov 29, 2021 4:11 am
Forum: Oracle APEX
Topic: Trigger to Assign sequence as PK
Replies: 0
Views: 117

Trigger to Assign sequence as PK

create or replace SEQUENCE JS_HEALTH_CHECK_seq start with 1 nocache;

CREATE OR REPLACE TRIGGER JS_HEALTH_CHECK_BIU
before insert OR UPDATE ON JS_HEALTH_CHECK
for each row
BEGIN
IF :NEW.ID IS NULL THEN
SELECT JS_HEALTH_CHECK_seq.nextval INTO :NEW.ID FROM sys.dual;
END IF;
END;
/
by admin
Mon Nov 22, 2021 2:08 am
Forum: Oracle APEX
Topic: Uninstall PWA
Replies: 0
Views: 123

Uninstall PWA

C:\Users\Sikandar\AppData\Local\WhatsApp

C:\Users\Sikandar\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Chrome Apps
by admin
Sat Nov 20, 2021 4:29 am
Forum: Oracle APEX
Topic: Check box in Interactive Reports
Replies: 0
Views: 124

Check box in Interactive Reports

-- A column to be added as below, so the user will check the lines and then in the process loop will insert values in a table. select ID, apex_item.checkbox2(1,PROFILE_ID) as "Select", name from js_users -- Process begin for i in 1..apex_application.g_f1.count loop apex_debug_message.log_m...
by admin
Thu Nov 18, 2021 2:19 am
Forum: Oracle APEX
Topic: Add or Remove Roles
Replies: 0
Views: 123

Add or Remove Roles

apex_acl.add_user_role ( p_application_id => wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); apex_acl.remove_user_role ( p_application_id => default wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); APEX_ACL....
by admin
Thu Nov 18, 2021 1:42 am
Forum: Oracle APEX
Topic: Setting Language Preference
Replies: 0
Views: 111

Setting Language Preference

apex_util.set_preference(
p_preference => 'FSP_LANGUAGE_PREFERENCE',
p_value => 'en-us'
);