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
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.
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
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
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.
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.
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.
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!
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