Anthony Harper

Working out at the Dev Gym since January 2022.

Accuracy

87%
Total Gym Time

94 d 3 h 40 m
Exercises Completed

5432

I have been working with Oracle SQL and PL/SQL since Oracle 8i. Because of my background in Philosophy I approach writing code like any writing activity, focusing on clarity and ease of understanding. I enjoy exploring new features as they are introduced in the Oracle platform. I really love the challenge of refactoring complex code for reusability and future maintainability. Database instrumentation of large PL/SQL implementations is my special focus. I also enjoy music, cooking, science fiction and everything Star Trek.

Website https://practicalplsql.org

Accomplishments

Trophies: 432

Points: 92248

Top Tournament Rank: 106 (Oracle Database)

Recent Trophy: Played All Quizzes in Week for Daily Quiz - SQuizL in Week of August 15 2026

Technologies

Autonomous Database	4 Quizzes Taken	0 Quizzes Authored
Database Administration	4 Quizzes Taken	0 Quizzes Authored
APEX	39 Quizzes Taken	0 Quizzes Authored
Oracle Database	275 Quizzes Taken	0 Quizzes Authored
Database Security	22 Quizzes Taken	0 Quizzes Authored
Database Design	1399 Quizzes Taken	4 Quizzes Authored
Internet Development	1 Quizzes Taken	0 Quizzes Authored
Java	8 Quizzes Taken	0 Quizzes Authored
Logic	92 Quizzes Taken	0 Quizzes Authored
Oracle Cloud Services	59 Quizzes Taken	0 Quizzes Authored
Oracle PL/SQL	3976 Quizzes Taken	45 Quizzes Authored
SQL	1978 Quizzes Taken	32 Quizzes Authored
SQuizL	754 Quizzes Taken	0 Quizzes Authored
Speed SQL	384 Quizzes Taken	0 Quizzes Authored
Groovy	2 Quizzes Taken	0 Quizzes Authored

Badges

My Quizzes

	Average Grade	Answers
How many days until Halloween?	71%	117
Explicitly naming constraints and other objects related to tables	64%	105
JSON Path Item Methods	64%	104
Top N Queries	76%	95
For each element of the collection	76%	93
Cursor For Loops with Dynamic SQL	60%	92
GROUP BY Extensions In 23ai	68%	89
Aggregating Intervals	64%	89
Where has the time gone	68%	85
Date, Timestamp and Timestamp With Time Zone Types	64%	82

row(s) 1 - 10 of 81

	Author Name	Pct Correct
CASE in PL/SQL	Tim Hall	100%
PL/SQL Challenge Championship for 2020	Steven Feuerstein	88%
Oracle Database 21c SQL Quizzes	Chris Saxon	100%
RETURNING Data from DML Statements	Steven Feuerstein	100%
Automatic Subprogram Inlining	Tim Hall	84%
Normally Normalized: Third Normal Form	Chris Saxon	100%
An Hour of Bulk Processing Quizzes	Steven Feuerstein	100%
Pipelined Table Functions	Tim Hall	88%
Pipelined Table Functions	Tim Hall	100%
PL/SQL Knowledge Survey	Steven Feuerstein	82%
Oracle Database 21c SQL Quizzes	Chris Saxon	86%
Oracle DevGym Live SQL at Trivadis	Kim Berg Hansen	83%
Introduction to Oracle Database Security	Richard C Evans	89%
Pi Day 2022	Oracle Developer Relations	65%
Love Your Database	Chris Saxon	76%

row(s) 1 - 15 of 69

	Author Name	Pct Correct
Nine Good-to-Knows for PL/SQL Error Management	Steven Feuerstein	95%
Databases for Developers: Performance	Chris Saxon	94%
Get Started with PL/SQL Table Functions	Steven Feuerstein	97%
Databases for Developers: Foundations	Chris Saxon	99%
Analytic SQL for Developers	Connor McDonald	91%
Databases for Developers: Next Level	Chris Saxon	93%

1 - 6

Anthony Harper

Accuracy

Total Gym Time

Exercises Completed

Biographical Info

Accomplishments

Technologies

Badges

My Quizzes

Workouts Taken

Classes Taken