Remote Network And System Administration Job In IT And Networking

An Oracle PL/SQL package enhancements/debugging

Find more Network And System Administration remote jobs posted recently Worldwide

I have a stored procedure in oracle DB that returns a table.

I need to do the following

1. Call the procedure from an oracle package
2. Use a table function to wrap the procedure
3. Use record type and table type as appropriate
4. Optimize the sql in the procedure given the execution plan that I have. Suggest and implement indexes as appropriate.

The goal is to execute this procedure from the table function which sits inside a package and it has to be efficient and fast.

About the recuiter
Member since Mar 14, 2020
Fira Safira
from Tamil Nadu, India

Skills & Expertise Required

Database Programming Oracle Oracle PLSQL sql Stored Procedure Development

Open for hiringApply before - Aug 23, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.92

Cost

Offer to work on this project closes in 51 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Move domain for emails to GSuite. - Fixed
Chief Architect Drafter - Hourly
Build a database of boat and sailing enthusiasts in the UK - Fixed
Data Manager For Start-Up Agency - Fixed
Full stack development - Hourly
Web site tool - Fixed
Collecting data and implementing it into website - Hourly
Google Sheets Expert - Fixed
Video Analytics / smart search of Video footage / machine learning of mp4 files - Hourly
Web Developer Needed - Fixed
hack time limit on dslr Sony a73 - Hourly
Need photo retoucher - Hourly
ACS RPL - Fixed

Similar Projects

Moodle BigBlueButton Record Video Download Module

I would like to have a module for Moodle BigBlueButton module, which will download the saved lessons to the computer. The existing BigBlueButton module only allows you to preview recordings and download the webcam. However, I want to download the ent...read more

php based application

Looking to hire someone to build a custom web based application that will do the following:

-Formatted into template
-Print ready from said template
-Re-Editable fields, easly clearable

So this is what is trying to be accomp...read more

Python SQL debugging

Im looking for someone to help me with python and SQL. If you know PySpark, that is a plus. This would be in person somewhere in the Des Moines area. A couple of hours a week.

R Developer

Im a data scientist and Im looking for an R developer (not an analyst or statistician).

You can write clear and efficient R code, you have experience with the tidyverse (primarily dplyr and purrr), and you know your way around relational d...read more

SQL PERFORMANCE CONSULTANT

SQL SERVER DATABASE
Need somebody to spend a day with all developers and then take a copy of our database and come back with structural and performance advise on how to make it as lean and efficient as possible.