ERPstuff - Oracle EBS Community

Whenever you format your code in TOAD a header line is displayed as below,
If you want to disable it use the following option,

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

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

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

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

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

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

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;
/

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

C:\Users\Sikandar\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Chrome Apps

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

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

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

SQL> select view_name from all_views where owner = 'APEX_210100'; VIEW_NAME -------------------------------------------------------------------------------- WWV_INSTALL_ERRORS WWV_FLOW_RT$SERVICES WWV_FLOW_RT$IDM_PRIVS WWV_FLOW_RT$APEX_ACCOUNT_PRIVS WWV_FLOW_CURRENT_SGID WWV_FLOW_CURRENT_WORKSPACES ...

Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 # listener.ora Network Configuration File: C:\app\Sikandar\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. DEFAULT_SERVICE_LISTENER = XE SID_LIST_LISTENER = (SI...

To add an image inside a region click the region and in the HTML Code property enter image reference which was uploaded in application static file as a shared component,

<img src="#APP_FILES#technology.jpg">