click the below link to download :

How to Set Background image in a Oracle Apex Login Page

To Remove Oracle + Apex Both :

Step 1 :
– Launch Oracle Universal Installer and Click – Deinstall
– Expand All existing Oracle Home and Select all and Click – Remove
Step 2 :

– Go to Run and type regedit.exe
– HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
– Now select all components regarding Oracle and Remove them.

Step 3 :
-Restart your machine
– Go to Program files and Remove folder “Oracle”
– Go to Oracle home Directory where you installed Oracle Database Software, Now Remove the
folder
– Now Remove all contents from “temp” folder , you will find temp folder under Program files or
Windows folder in drive c.
After completing above process your machine is completely free from Oracle environment. Now you can
install fresh Oracle Database. Oracle Apex will be destroyed in this process.

To Remove only Oracle Apex :

Log in as SYS with SYSDBA privilege.
SQL> SELECT USERNAME FROM DBA_USERS;
……………….
……………….
APEX_040100
APEX_030200
Now Drop Apex 4 After executing below command.
SQL> DROP USER APEX_040100 CASCADE;

Example below to display checkbox :

SELECT EMPNO,apex_item.checkbox(1,EMPNO,'UNCHECKED') as Checkbox,ENAME,SAL,JOB,HIREDATE FROM EMP


To set up checkbox in the column header:
Go to column header of “Checkbox” column and type the header text as under:

Click the blow link and you will get the pdf file for step by step solution :

–>Click here to download Solution

Create a PL/SQL Process under a Button Control.

Copy the below process text and paste into your PL/SQL process.
Process Text :

APEX_UTIL.CLEAR_PAGE_CACHE('61');

Note :
here 61 is the page number that need to clear it’s cache. put your own page no. here.

click below to download :
How to upload and display images in apex

download below file :
How to Change APEX Themes after APEX Installation

Download complete documents

Note : if you want to access/operate Apex application from other computer then Case 1 applicable Otherwise if you want locally then Case 2 applicable.

Case 1. Url : http:// ComputerName: Port / apex
or http:// IPaddress: Port / apex

Case 2. Url : http://localhost: /apex

For Case 1 if you are not able to access the application then have to enable network access true.
to do so, you have to logon as Sys with Sysdba privilege and execute the following command.
—————Command——————————————-
execute dbms_xdb.setListenerLocalAccess(l_access => FALSE);
——————————————————————–
Note : just copy the above command and paste into your SQL Editor and execute.
After scuccessfull execution of the above command.
if the remote computer name is ABC and apex access port 8080 then your url will be as

http://abc:8080/apex

http://119.18.144.201:8080/apex

Before running Script type :

SET DEFINE OFF;