I will write, debug and optimize complex oracle sql and plsql queries

Pavan K.

India

I speak English

Oracle APEX and PLSQL Developer

Technical lead with 4+ years building and maintaining production business apps on Oracle APEX and Oracle Autonomous Database: approvals, HR and recruitment, purchase orders, invoicing and compliance t...
Read More
About this Gig

Need a tricky Oracle SQL query written, a slow report sped up, or a PL/SQL procedure that finally works?


I write and tune SQL and PL/SQL every day for production business applications on Oracle Database and Autonomous Database.


What I can do:

  • Complex queries: joins, analytic and window functions, hierarchical queries, pivots
  • Reporting views and data checks
  • PL/SQL procedures, functions, packages and triggers
  • Bulk processing, exception handling and logging
  • Performance tuning with execution plans, indexes and query rewrites

What you get:

  • Tested SQL or PL/SQL with comments
  • A short note explaining the approach
  • Before and after timings for tuning work

Please message me before ordering with your Oracle version, table structures (DDL) and a few sample rows, so I can confirm the right package.

Read More
write, debug and optimize complex oracle sql and plsql queries
Full Screen
write, debug and optimize complex oracle sql and plsql queries
Full Screen
write, debug and optimize complex oracle sql and plsql querieswrite, debug and optimize complex oracle sql and plsql queries

Database type:

Relational database

Platform:

Oracle

•

PL/SQL

Expertise:

SQL

•

DML

•

Performance

•

Query optimization

Other Databases Services I Offer

Related tags