SELECT * from APEX_MAIL_QUEUE ORDER BY LAST_UPDATED_ON DESC;
SELECT * from APEX_MAIL_LOG ORDER BY LAST_UPDATED_ON DESC;
Search found 2063 matches
- Sun Jan 08, 2023 6:01 am
- Forum: Oracle APEX
- Topic: Oracle APEX Emal Queue SQL
- Replies: 0
- Views: 104485
- Sun Dec 18, 2022 6:45 am
- Forum: Oracle APEX
- Topic: Steps to stop and start Apache Tomcat on Linux/Solaris
- Replies: 0
- Views: 103174
Steps to stop and start Apache Tomcat on Linux/Solaris
Here are steps to stop and start Apache Tomcat on Linux/Solaris
cd to /bin folder inside tomcat folder.
Stop
./shutdown.sh
Start
./startup.sh
cd to /bin folder inside tomcat folder.
Stop
./shutdown.sh
Start
./startup.sh
- Wed Dec 14, 2022 3:44 am
- Forum: Oracle APEX
- Topic: Unlock and Change Oracle APEX Password
- Replies: 0
- Views: 101667
Unlock and Change Oracle APEX Password
Here are steps to change your Oracle APEX admin password, APEX_220200 schema is your current schema as per your version of APEX, SELECT * FROM APEX_220200.WWV_FLOW_FND_USER A WHERE ACCOUNT_LOCKED = 'Y'; BEGIN APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10); APEX_UTIL.UNLOCK_ACCOUNT(P_USER...
- Sun Nov 20, 2022 6:37 am
- Forum: Oracle APEX
- Topic: IG Manually processing data
- Replies: 0
- Views: 100349
IG Manually processing data
You might need to process each row of IG manually so the following code will be executed as a loop for each changed row, Screenshot 2022-11-20 113639.jpg begin case :APEX$ROW_STATUS when 'I' then insert into emp ( empno, ename, deptno ) values ( :EMPNO, :ENAME, :DEPTNO ) returning rowid into :ROWID;...
- Fri Nov 18, 2022 3:19 am
- Forum: Oracle APEX
- Topic: IG-Interactive Grid and JavaScript
- Replies: 5
- Views: 62669
IG-Interactive Grid and JavaScript
Initialization JavaScript Function function(config) { if (!config.toolbar) { config.toolbar = {}; } config.reportSettingsArea = false; config.defaultGridViewOptions = { multiple: true, selectAll: true , footer: true, rowHeader: 'sequence' } // config.initActions = function( actions ) { // actions.r...
- Wed Nov 02, 2022 5:25 am
- Forum: Oracle APEX
- Topic: Calculate schema size in MB
- Replies: 1
- Views: 5889
Calculate schema size in MB
Normally companies are giving APEX as a service and they need to calculate the space used by each Schema/WS,
select owner, sum(bytes)/1024/1024 Size_MB from dba_segments
group by owner;
select owner, sum(bytes)/1024/1024 Size_MB from dba_segments
group by owner;
- Tue Nov 01, 2022 2:50 pm
- Forum: Oracle APEX
- Topic: Public Holidays adjustment during Leaves
- Replies: 0
- Views: 103962
Public Holidays adjustment during Leaves
This procedure is to count public holidays or any type of holidays that you don't want to count in the range of employee leaves and wants to adjust those number of days. For example, you have public holidays from the 4th to the 6th of a month means 3 days are public holidays. If an employee had appl...
- Tue Nov 01, 2022 2:48 am
- Forum: Oracle APEX
- Topic: ACL Roles Views
- Replies: 0
- Views: 104080
ACL Roles Views
APEX_APPL_ACL_USERS
APEX_APPL_ACL_USER_ROLES
APEX_APPL_ACL_ROLES
APEX_APPL_ACL_USER_ROLES
APEX_APPL_ACL_ROLES
- Wed Oct 19, 2022 6:24 am
- Forum: Oracle APEX
- Topic: Check which page button is pressed?
- Replies: 0
- Views: 105508
Check which page button is pressed?
Begin
if V('REQUEST') = 'OK' Then -- Here OK is the button name which can be Submit, Cancel, Delete etc.
return true;
else
return false;
end if;
End;
if V('REQUEST') = 'OK' Then -- Here OK is the button name which can be Submit, Cancel, Delete etc.
return true;
else
return false;
end if;
End;
- Fri Sep 16, 2022 4:29 am
- Forum: Application DBA & System Administration
- Topic: JDeveloper Installation
- Replies: 0
- Views: 34039
JDeveloper Installation
Unable to launch the Java Virtual Machine Located at path: ..\..\jdk\jre\bin\client\jvm.dll
C:\Oracle\OAF_p28163665_R12\jdevbin\jdev\bin\jdev.conf
SetJavaHome C:\Program Files (x86)\Java\jre1.8.0_201
https://www.oracle.com/java/technologie ... loads.html
C:\Oracle\OAF_p28163665_R12\jdevbin\jdev\bin\jdev.conf
SetJavaHome C:\Program Files (x86)\Java\jre1.8.0_201
https://www.oracle.com/java/technologie ... loads.html
- Sat Sep 10, 2022 3:52 am
- Forum: Oracle Forms & Reports
- Topic: INST-07545: Unexpected Error java.lang.NullPointerException
- Replies: 0
- Views: 15607
INST-07545: Unexpected Error java.lang.NullPointerException
Oracle WebLogic Server - Version 12.2.1.0.0 and later Oracle Fusion Middleware - Version 12.2.1.0.0 and later While installation of Forms and Reports Builder 12c selecting home you might get this error INST-07545. You need to set TEMP folder environment variable in windows OS, Set temp environment v...
- Fri Sep 09, 2022 8:16 am
- Forum: Oracle Forms & Reports
- Topic: Download Forms & Reports 12c
- Replies: 0
- Views: 13558
- Mon Sep 05, 2022 5:38 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: Upgrading form6i and report6i to 11g/12c?
- Replies: 0
- Views: 24956
Upgrading form6i and report6i to 11g/12c?
It is always recommended to upgrade to the latest version of any product while Oracle Developer 6i is already obsolete by Oracle and de-supported. Few companies due to different factors can't upgrade so here we will share to stay with 6i and connect to 12c and higher versions or how to upgrade. Para...
- Tue Aug 30, 2022 7:47 am
- Forum: Oracle APEX
- Topic: Oracle API Reference Document 21.2
- Replies: 0
- Views: 13881
- Sun Aug 28, 2022 8:51 am
- Forum: Oracle APEX
- Topic: Sum two tables column in single SQL
- Replies: 0
- Views: 13989
Sum two tables column in single SQL
CREATE TABLE ALLOW (ANO NUMBER(3), ANAME VARCHAR2(15), CONSTRAINT ANO_PK PRIMARY KEY (ANO)); CREATE TABLE DED (DEDNO NUMBER(3), DEDNAME VARCHAR2(20), CONSTRAINT DEDNO_PK PRIMARY KEY (DEDNO)); CREATE TABLE EMP(ENO NUMBER(5), ENAME VARCHAR2(20), CONSTRAINT ENO_PK PRIMARY KEY(ENO)); CREATE TABLE EMPA(E...