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 Nov 11, 2022
Ritesh Senta
from Baden-Wurttemberg, Germany

Skills & Expertise Required

Database Programming Oracle Oracle PLSQL sql Stored Procedure Development

Open for hiringApply before - Oct 14, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.64

Cost

Offer to work on this project closes in 29 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

Promoting DIet Your Way to potential partners! - Fixed
Create a site on Wordpress with Woocommerce - Hourly
Web Design - Hourly
Google Shopping Actions Set Up - Hourly
Data Processor for Excel List - Hourly
UX/UI & Graphic designer needed - Hourly
Data Mining/ Extraction - Fixed
SMTP Wordpress Plugin Urgent FIX need it done NOW - Hourly
Create a Wordpress website for a startup medical PPE reseller - Fixed
Save photos from website to desktop then upload to cloud - Fixed

Similar Projects

IFS Development

IFS ERP Technical Developer
Form and Reports in Order Report,
Crystal reports
Quick Report
Using Ifs Reports Designer, PLSQ
Giving solution through ifs solution manager.
Understanding the business requirements and Softwar...read more

MySQL Database Manager/Expert - Help needed uploading product database to WordPress website

Were in the process of uploading a product database totaling around 300,000 products onto a WordPress website. Our current developer cannot continue to work on the project and we need assistance ASAP. We need someone who can manage the database uplo...read more

Creating Auditing triggers in SQL server table

To create a trigger that will populate an audit table to store changes to existing records and when new records are added to the table.
I need to see who changed what, when it was changed and what operations were performed.

Data Wrangler needed to help with matching complex data sets

Looking for someone skilled at data wrangling, processing, and cleaning. This is a job that needs to be done as soon as possible. You will work on getting financial and medical data into a useable form. There are many data sets that need to be matche...read more

Developer needed with chrome Devtools experience

I need certain information to be extracted from Devtools console, it involves expending Parent and child nodes.