Search found 2029 matches

by admin
Wed Feb 08, 2023 10:18 am
Forum: Oracle APEX
Topic: Oracle APEX - Commenting Tips & Tricks - VIDEO
Replies: 0
Views: 6

Oracle APEX - Commenting Tips & Tricks - VIDEO

Oracle APEX - Commenting Tips & Tricks The commenting feature in Oracle Application Express (APEX) allows developers to add notes or explanations to their code. This can be helpful for collaboration, debugging, or just keeping track of what different parts of the code do. Oracle PL/SQL Developer...
by admin
Mon Feb 06, 2023 1:18 pm
Forum: IT Jobs
Topic: Oracle DBA, EBS Functional & DBA for Karachi
Replies: 0
Views: 57

Oracle DBA, EBS Functional & DBA for Karachi

1-3 Primary Oracle DBA Duties: Oracle 12/19c administration and support (on-prem or cloud) Oracle Patch Management Coordination and implementation Oracle backup and recovery planning/testing Provide infrastructure support at all levels and after hours support as needed Coordinate Oracle DB work wit...
by admin
Sat Feb 04, 2023 8:32 am
Forum: Oracle APEX
Topic: IG Highlight color and Hide controls
Replies: 0
Views: 18

IG Highlight color and Hide controls

function(config) { config.reportSettingsArea = false; // may want to disable the highlights feature. Comment out this code to make initial highlight settings apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; } IG color.jpg IG color2.jpg
by admin
Tue Jan 31, 2023 1:04 pm
Forum: Oracle APEX
Topic: Size settings of Image Interactive Report
Replies: 0
Views: 31

Size settings of Image Interactive Report

1. Assing a static ID like PHOTO_BLOB to your image field and type of this field should be Display Image.
2. In the page inline CSS following code,

td[headers="PHOTO_BLOB"] img {width: 64px;}
by admin
Thu Jan 26, 2023 4:47 am
Forum: General / Others
Topic: Windows Print Screen Output Folder
Replies: 0
Views: 40

Windows Print Screen Output Folder

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
by admin
Sun Jan 22, 2023 6:24 am
Forum: Oracle APEX
Topic: GET_SINCE Function Date Formatting like ago
Replies: 0
Views: 24

GET_SINCE Function Date Formatting like ago

APEX_UTIL.GET_SINCE (
p_date DATE )
p_short IN [ BOOLEAN DEFAULT FALSE | VARCHAR2 DEFAULT 'N' ] )
RETURN VARCHAR2;

select application_id, application_name,apex_util.get_since(last_updated_on) last_update
from apex_applications
order by application_id

Sample output,
format.jpg
by admin
Wed Jan 18, 2023 12:48 pm
Forum: Oracle APEX
Topic: Restricted workspace may not perform this action?
Replies: 0
Views: 38

Restricted workspace may not perform this action?

In Autonomous database if you are unable to delete application "Restricted workspace may not perform this action" as an admin then you can use following script,

begin
wwv_flow_api.remove_flow(101);
end;
autono.jpg
by admin
Tue Jan 17, 2023 3:21 pm
Forum: Oracle APEX
Topic: Who Columns
Replies: 0
Views: 31

Who Columns

"CREATED_BY" VARCHAR2(15),
"CREATION_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(15),
"UPDATION_DATE" DATE,
by admin
Sun Jan 15, 2023 8:03 am
Forum: Oracle APEX
Topic: How to upgrade Oracle APEX?
Replies: 0
Views: 44

How to upgrade Oracle APEX?

@apexins1.sql SYSAUX SYSAUX TEMP /i/ @apexins2.sql SYSAUX SYSAUX TEMP /i/ @apexins3.sql SYSAUX SYSAUX TEMP /i/ Copy and Replace images in the web folder /i @catpatch BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( host => '*', ace => xs$ace_type(privilege_list => xs$name_list('connect'), principal_nam...
by admin
Wed Jan 11, 2023 3:18 pm
Forum: Oracle Projects & Property Manager
Topic: Range of “Tasks" within a project
Replies: 1
Views: 79

Re: Range of “Tasks" within a project

Please share some sample data for better understanding. thanks
by admin
Sun Jan 08, 2023 6:01 am
Forum: Oracle APEX
Topic: Oracle APEX Emal Queue SQL
Replies: 0
Views: 49

Oracle APEX Emal Queue SQL

SELECT * from APEX_MAIL_QUEUE ORDER BY LAST_UPDATED_ON DESC;

SELECT * from APEX_MAIL_LOG ORDER BY LAST_UPDATED_ON DESC;
by admin
Sun Dec 18, 2022 6:45 am
Forum: Oracle APEX
Topic: Steps to stop and start Apache Tomcat on Linux/Solaris
Replies: 0
Views: 92

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
by admin
Wed Dec 14, 2022 3:44 am
Forum: Oracle APEX
Topic: Unlock and Change Oracle APEX Password
Replies: 0
Views: 87

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...
by admin
Sun Nov 20, 2022 6:37 am
Forum: Oracle APEX
Topic: IG Manually processing data
Replies: 0
Views: 268

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