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 May 20, 2018
Phani Kumar
from Norte, Portugal

Skills & Expertise Required

Database Programming Oracle Oracle PLSQL sql Stored Procedure Development

Candidate shortlisted and hiredHiring open till - Nov 14, 2021

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.73

Cost

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

Mobile car service IOS/Android - Fixed
1830 Lefthand Final Lighting design & Photometrics Docs - Hourly
Financial Excel Spreadsheet with API - Fixed
Need GoDaddy SSL installed on AWS for Https ASAP - Hourly
Content writer needed for news reading platform for kids - Hourly
Looking for a T-Shirt Designer - Fixed
Photo Editing For Amazon - Hourly
SEO web designer - Fixed
Prepare a Leave Tracking System with Google Apps - Fixed
Create a phone app - Hourly
Multi vendor E commerce web. - Fixed
Developer needed to implement a site redesign. - Fixed
Online Leasing Application - Fixed
PowerShell Developer - Hourly
Web research and gathering contact data - Fixed

Similar Projects

PostGreSQL-Vacuum Expert needed

We have a Ruby code base that runs multiple jobs on our website. We deployed a piece of code and saw that it bloated up one table in our database because of several updates that happened in this table due to the code.

We need 3 things in th...read more

Airflow Consulting

Looking for an airflow expert to guide my ETL project workflow (get data from rest and database).

Created and modify features in symfony

We need to update some features that we have in an application developed in Symfony.

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

Looking for MS Access / SQL /Data Visualization Engineer to create Solution Architecture Doc

We are having a requirement document with an access data file, the goal is to build a real-time dashboard to visualize this data. In the first step, we are looking for a solutions architect to help us to create a scope and architecture document.