This Python script farms points for the "Top Users" leaderboard on Oracle Academy Application Express.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Matei-Alexandru Gardus 78ccf7853c
Add all queries in one master file
1 year ago
LICENSE Initial commit 1 year ago Initial commit 1 year ago Add comment functionality to text files 1 year ago
queries.txt Add all queries in one master file 1 year ago
queries_employees.txt Modify Employee Queries 1 year ago


This script runs random SQL dummy queries from a text file on an APEX browser window to accumulate points on the “Top Users” board


Oracle Academy Application Express has a “Top Users” leaderboard, where points are awarded for doing work on APEX. However, there are no limitations to how you receive those points. Running random SQL queries in a dummy table suffice for easy points gathering.


You need PyAutoGui for this script to work. Install using:

python -m pip install pyautogui

Then clone this repository:

git clone

You will need to open your APEX on a browser window, and enter the “SQL Commands” section, where you can run all the dummy SQL queries, and maximize the browser window to make sure all the space is used.

After setup, run the script:



The random queries run are saved in queries.txt. If you wish to customize the queries run at random, change the file and add one SQL query to run per line.