I will write, fix and optimize oracle sql and pl sql queries


About this gig
I will write, fix, and optimize Oracle SQL and PL/SQL queries based on your requirements. I can develop complex SQL queries, stored procedures, functions, packages, database automation, and performance optimization. I can also troubleshoot Oracle errors and improve existing SQL/PLSQL code. Clean, reliable, and efficient solutions with proper testing and clear communication.
Get to know zabaasl77
"I Create Your Vision"
- FromSri Lanka
- Member sinceDec 2022
- Avg. response time2 days
Languages
English, Sinhala, Tamil
FAQ
Q: What information do you need to start the project?
Please provide your requirements, SQL/PLSQL code if available, table structures, sample data, and any error messages or expected results.
Can you fix Oracle SQL and PL/SQL errors?
Yes. I can troubleshoot and fix Oracle SQL/PLSQL errors, including query errors, procedure/function errors, package compilation issues, and other database-related problems.
Can you optimize a slow SQL query?
Yes. I can analyze your SQL query, joins, filters, subqueries, and execution plan and provide an optimized solution to improve performance.
Can you develop PL/SQL procedures and functions?
es. I can develop and modify PL/SQL procedures, functions, packages, triggers, and database automation based on your requirements.
Do you work with existing PL/SQL code?
Yes. I can review, debug, modify, optimize, and enhance your existing Oracle SQL and PL/SQL code.
Do you provide database automation?
es. I can develop database automation processes, scheduled tasks, data processing, validation, and reporting solutions using Oracle SQL and PL/SQL.
