Search found 1982 matches

by admin
Thu Jan 27, 2022 4:44 pm
Forum: Oracle APEX
Topic: Built-in substitution names
Replies: 0
Views: 5

Built-in substitution names

The built-in substitution names are:

&APP_USER.
&APP_ID.
&APP_PAGE_ID.
&APP_SESSION.
&APP_FILES.
&WORKSPACE_FILES.
&REQUEST.
&DEBUG.
&APEX_FILES.
&IMAGE_PREFIX. (legacy- use &APEX_FILES. instead)
&APEX_VERSION.
by admin
Wed Jan 26, 2022 1:28 pm
Forum: Oracle APEX
Topic: Upload Multiple files into table code
Replies: 0
Views: 7

Upload Multiple files into table code

create table erpstuff_files (name VARCHAR2(400), filename VARCHAR2(400), mime_type VARCHAR2(255), created_on date, blob_content blob); declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :P2_DOC, p_sep => ':' ); for i i...
by admin
Sat Jan 22, 2022 6:37 am
Forum: Oracle APEX
Topic: ORDS Scripts
Replies: 0
Views: 54

ORDS Scripts

GET declare l_clob clob; json_content APEX_JSON.t_values; v_lines number; begin l_clob:= apex_web_service.make_rest_request( p_url => 'https://apex.oracle.com/pls/apex/erpstuffords/hr/dept', p_http_method => 'GET', p_parm_name => apex_util.string_to_table('deptno'), p_parm_value => apex_util.string_...
by admin
Sat Jan 22, 2022 6:35 am
Forum: Oracle APEX
Topic: ORDS Setup plsql
Replies: 0
Views: 49

ORDS Setup plsql

DECLARE v_module_name VARCHAR2 (200) DEFAULT 'erpstuff.com.hr'; v_pattern VARCHAR2 (200) DEFAULT 'dept/:deptno'; /* This code is only for demo purposes so use this code in your environment at your own risk. https://erpstuff.com version:demo_1 22-JAN-2022 */ BEGIN ORDS.define_module (p_module_name =...
by admin
Thu Jan 20, 2022 6:31 am
Forum: Order Management
Topic: How to handle a rental business in oracle
Replies: 2
Views: 2143

Re: How to handle a rental business in oracle

Please explore following,

Equipment Lease - A New functionality in Oracle Property Manager
by admin
Thu Jan 20, 2022 6:26 am
Forum: Oracle APEX
Topic: PWA Chrome Setting
Replies: 0
Views: 19

PWA Chrome Setting

chrome://flags/#pwa-uninstall-in-windows-os
by admin
Thu Dec 30, 2021 6:30 am
Forum: Oracle APEX
Topic: APEX EMAIL Queue SQL
Replies: 0
Views: 190

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: 92

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: 112

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: 180

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: 146

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: 148

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: 139

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: 145

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: 263

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" ...