Anthony Harper

Working out at the Dev Gym since January 2022.

Accuracy

88%
Total Gym Time

83 d 18 h 44 m
Exercises Completed

3859

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: 276

Points: 79347

Top Tournament Rank: 101 (Oracle Database)

Recent Trophy: Played All Quizzes in Week for Daily Quiz - Featured Oracle PL/SQL in Week of September 27 2025

Technologies

Database Administration	4 Quizzes Taken	0 Quizzes Authored
APEX	39 Quizzes Taken	0 Quizzes Authored
Oracle Database	211 Quizzes Taken	0 Quizzes Authored
Database Security	22 Quizzes Taken	0 Quizzes Authored
Database Design	1155 Quizzes Taken	4 Quizzes Authored
Internet Development	1 Quizzes Taken	0 Quizzes Authored
Java	6 Quizzes Taken	0 Quizzes Authored
Logic	65 Quizzes Taken	0 Quizzes Authored
Oracle Cloud Services	53 Quizzes Taken	0 Quizzes Authored
Oracle PL/SQL	3627 Quizzes Taken	38 Quizzes Authored
SQL	1721 Quizzes Taken	21 Quizzes Authored
SQuizL	476 Quizzes Taken	0 Quizzes Authored
Speed SQL	99 Quizzes Taken	0 Quizzes Authored

Badges

My Quizzes

	Average Grade	Answers
How many days until Halloween?	70%	116
Explicitly naming constraints and other objects related to tables	63%	101
Cursor For Loops with Dynamic SQL	60%	91
JSON Path Item Methods	64%	88
For each element of the collection	76%	87
Top N Queries	75%	86
Date, Timestamp and Timestamp With Time Zone Types	64%	82
GROUP BY Extensions In 23ai	68%	81
Aggregating Intervals	63%	81
Using Others with record types	61%	80

row(s) 1 - 10 of 63

	Author Name	Pct Correct
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%
Know the Difference: RANGE and ROWS in Window Clause	Kim Berg Hansen	98%
CONTINUE in PL/SQL Loops	Tim Hall	78%
Advanced PL/SQL (formerly the Chicago OUG Workout)	Steven Feuerstein	85%

row(s) 1 - 15 of 61

	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