How to change Apex theme’s images after apex installation. I have shared the .PDF file below for your convenient. Please download the file from below link and have the step by step by guide Here is the document download Thank You
How to assign word wrap and fix column width in Apex Report Go to : Column Attributes of your Report > Go to Column Property > Go to HTML expression and type as :
|
1 |
<span style="width: 80px; display: block; white-space: normal; font-size: 11px;">#NAME#</span> |
OR
|
1 |
<span style="width: 80px; display: block; white-space: pre-line; font-size: 11px;">#NAME#</span> |
Note : here “NAME” is the column name that need to fix width …
How to stop XDB Authentication window in Apex Log in as SYS with SYSDBA Privilege in the database
|
1 |
SQL> SET SERVEROUTPUT ON; |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
DECLARE l_configxml XMLTYPE; l_value VARCHAR2(5) := ‘true’; — (true/false) BEGIN l_configxml := DBMS_XDB.cfg_get(); IF l_configxml.existsNode(‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access’) = 0 THEN – Add missing element. SELECT insertChildXML ( l_configxml, ‘/xdbconfig/sysconfig/protocolconfig/httpconfig’, ‘allow-repository-anonymous-access’, XMLType(‘‘ || l_value || ‘‘), ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘ ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line(‘Element inserted.’); ELSE – Update existing element. SELECT updateXML ( DBMS_XDB.cfg_get(), ‘/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()’, l_value, ‘xmlns=”http://xmlns.oracle.com/xdb/xdbconfig.xsd”‘ ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line(‘Element updated.’); END IF; DBMS_XDB.cfg_update(l_configxml); DBMS_XDB.cfg_refresh; END; / |
Note : the above procedure must be executed successfully. Also execute the below command, you can copy and paste and execute :
|
1 |
SQL > ALTER USER ANONYMOUS IDENTIFIED BY anonymous; |
|
1 |
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK; |
|
1 |
SQL> ALTER USER XDB IDENTIFIED BY xdb; |
|
1 |
SQL> ALTER USER XDB ACCOUNT UNLOCK; |
After completing above steps …
How to Install Apex 4.2.1 using Oracle WebLogic Server Please download the below link for .PDF file where you will find the step by step guide for complete installation and configuration of a) Oracle Database b) Oracle Apex c) Oracle WebLogic Server Please download the complete steps from this document …
How to increase Button Width and height in Apex You can increase the button width and Height as the following way : Go to Button Property : In Attributes field type below :
|
1 |
style = "margin:20px 0px 20px 0px; padding:30px 70px 30px 70px;" |
here for margin first 20px = top next 0px = right next 20px = bottom next …
How to Clear Page cache in Apex by clicking a command button Please follow the below steps : Create a PL/SQL Process and type the below text as PL/SQL process code :
|
1 |
APEX_UTIL.CLEAR_PAGE_CACHE('61'); |
Now Make sure you have made this process conditional with Button Click. Note : here 61 is …
How to Add Manual check box and Check all check box in a grid Step 1 : Add check box in a classic report : Take a classical report and go the query source and type the query as the following way so that there is a column of checkbox
|
1 2 3 4 5 6 7 8 |
SELECT EMPNO, apex_item.checkbox(1,EMPNO,'UNCHECKED') as Checkbox, ENAME,SAL, JOB, HIREDATE FROM EMP |
…
How to find user session details in Oracle Apex You can use the below SQL query find Active session details:
|
1 2 3 4 5 |
SELECT * FROM APEX_WORKSPACE_SESSIONS WHERE APEX_WORKSPACE_SESSIONS.SESSION_CREATED >= SysDate - 1 |
Thank You
