Find Jobs
Hire Freelancers

Oracle PL/SQL Project

$30-250 AUD

Closed
Posted over 7 years ago

$30-250 AUD

Paid on delivery
I need someone to create the PL/SQL scripts that are included in description below. The database is already created i just need someone to make the PL/SQL scripts. I also need you to fix up some of the queries that are not functioning properly. So feel free to change some of the tables or alter them. It also has to be done within 24hrs. SQL quires: · Show how many orders were made in September 2016 ( or other month matching your data) · Show the item name which is on a greatest number of orders · Show the shop name with the total cost of all orders greater than average · Retrieve the names of a items which are not on any order · List all order details (customer name, item name, quantity, and date ) for all orders in the nearest month (the last month matching your data) · Update a particular order changing its dispatch date to later ( make up the date) plsql: 1. Create a procedure display_orders() that takes a customer id as a parameter and displays all the orders’ details for this customer (customer name, item name, quantity, total price, and order date). Create also anonymous block to prompt for customer id and to run the procedure. 2. Create a procedure to insert a new order for a customer. Use all required values as input parameters. Create also anonymous block to prompt for customer id and run the procedure 3. Create a procedure to update a certain item changing quantity in stock. Use all required values as input parameters. Create also anonymous block to prompt for item id and to run the procedure. 4. Create a procedure which displays all suppliers for a particular item. Use item id as an input parameter. Create also anonymous block to prompt for item id and to run the procedure
Project ID: 11887502

About the project

32 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average $144 AUD for this job
User Avatar
Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.
$50 AUD in 1 day
5.0 (81 reviews)
5.6
5.6
User Avatar
I have more than 7 years of experience in IT industry.I have worked on SQLSERVER and Oracle.I can provide you better solution by utilizing my knowledge and skills.
$200 AUD in 5 days
4.9 (29 reviews)
4.8
4.8
User Avatar
i am oracle dba having more then 10 yrs of experience..............................................i can complete this task in one day........
$111 AUD in 1 day
4.6 (30 reviews)
4.5
4.5
User Avatar
Hello, I am interested in your project. I am a software engineer and I have professional experience with PL/SQL. Thank you, Best regards, David
$100 AUD in 1 day
5.0 (17 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$300 AUD in 10 days
5.0 (6 reviews)
3.5
3.5
User Avatar
I have experiences in SQL for more than 6 years. Please contact and let me know in details your project
$177 AUD in 3 days
5.0 (2 reviews)
3.2
3.2
User Avatar
HI, I can produce your sql scripts. Please send me the script to create the tables. Have a nice day Angelo
$133 AUD in 2 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hello, Myself Barduga, I have expertise in Oracle SQL and PLSQL development and have completed many projects. I can help you out in this task. Please feel free to discuss with me. Warm Regards Barduga
$220 AUD in 2 days
5.0 (5 reviews)
2.6
2.6
User Avatar
Hi, I can give you the queries and plsql objects today. But I need the database structure before, so please export it to an sql file (or grant me access to your database). I'm an Oracle Certified Professional (Oracle certification), so I'm 100% sure I can do this :) Regards, Cristian
$133 AUD in 1 day
5.0 (6 reviews)
2.5
2.5
User Avatar
Dear Sir, I am interested for your project. Please check my profile. I have done multiple projects like this PL/SQL Regards Wahid
$222 AUD in 10 days
5.0 (5 reviews)
2.7
2.7
User Avatar
I have more than 10 years of experience with SQL queries. Please provide DDL of your database and some test data.
$75 AUD in 3 days
5.0 (5 reviews)
1.7
1.7
User Avatar
Introduction & skills: I have good knowledge in below mentioned skills by you. I also have some certifications in Java. I can share some of demos with you if you want for better understanding. Currently I'm working on a banking project in an IT company using Java, jsp/jsf, hibernate, spring, software architecture and database programming(pl/sql). And most importantly, you will get your project done before the deadline. Experience: We are serving our customers since 2012 and on freelancer since 2015.
$100 AUD in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
i have 2 year experience in mysql. already eork on oracle . and have beat quries. join. procedure. i think i will do this axctly u want. bat wishea
$200 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I recently worked database project that requires query tables.
$166 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am OCA and OCP certified person with experiece in writing stored procedure in Oracle. I am also Java/J2EE web based programmer. Available on full time basis as currently not working. Please send personal message for further collaboration.
$155 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am interesting to work with you , i am working as database administration nowadays. so i will give professional code and enhance the performance bu using sql tuning . i worked as developer from 10 years tell now . Ready to work now, waiting your interview.
$166 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi. I'm an Oracle developer for more than 15 years now. I have also tuned many SQL queries. I intend to finish the task in 1-2 days but all under 24 hours. Below is my proposed outline plan/milestones. Please do contact me to cross this off your list. Thanks!
$163 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm PL/SQL developer with 2+ years of professional experience. I have all necessary tools ready and setup, and I'm ready to start working immediately. Best regards
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a PL/SQL expert. Please consider!
$95 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
8
Payment method verified
Member since Nov 30, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.