Browse categories
Explore
Fiverr Pro
English
$
USD
I will write fix and optimize oracle sql queries and pl sql procedures
About this Gig
I will write, troubleshoot and optimize Oracle SQL queries and small PL/SQL routines for reporting and data tasks.
My background includes Oracle SQL and PL/SQL development at Bank of Georgia and banking systems analysis.
I can help with:
- SELECTs, JOINs, aggregations, subqueries and CTEs
- Debugging incorrect results and SQL errors
- Query optimization and execution-plan review
- Small PL/SQL routines and SQL reporting logic
Basic: 1 simple query.
Standard: up to 3 queries.
Premium: up to 5 queries OR 1 small PL/SQL routine.
You receive a commented .sql file, tests against agreed sample data, and brief run instructions. Revisions cover the agreed requirements.
Please message me before ordering with your Oracle version, table definitions, anonymized sample data and expected output so I can confirm scope and delivery. Performance improvements depend on your data, indexes and environment; no fixed speedup is promised.
Complex routines, database administration and production deployment need separate scoping.
Database type:
Relational database
Platform:
Oracle
•
PL/SQL
Expertise:
SQL
•
DML
•
DQL
•
Query optimization
FAQ
What do you need to start?
Please provide your Oracle version, table definitions, anonymized sample data, expected output, existing SQL and any error messages. For optimization, include an execution plan if available. Send project files through Fiverr; database passwords are not needed to assess the scope.
Does Premium include both queries and a procedure?
Premium covers up to five queries OR one small PL/SQL procedure, not both. Please send the requirements before ordering. Complex procedures, additional objects or a larger query set require a separate quote.
Can you guarantee a specific performance improvement?
No fixed speedup is promised. Results depend on data volume, indexes, execution plans and the environment. I review the SQL, propose improvements, and test against the agreed sample data.
Which databases do you support?
This gig focuses on Oracle SQL and PL/SQL. Please confirm your database version before ordering. Work for another database engine must be discussed and agreed separately.
