Relational Database Management
$10-30 CAD
Pagado a la entrega
For procedure: Write sql script to create a stored procedure which accepts a customer name as a parameter and returns the total amount the customer has spent buying cars.
• Write sql code to test the script. System must ask user to input the data.
For function: Write sql script to create a function to return the total number of options on a car given the serial number of the car. Include both base options and invoice options.
• Write sql code to test the script. System must ask user to input the data.
For trigger: Write sql script to create a trigger that converts to upper case the serial, make, model, color of the car table during INSERT OR UPDATE.
Write sql code to test script. System must ask user to input the data.
Create procedure in pl/sql block to input two numbers and store the result in third number. Call the procedure in three different waye: 1. named notation, 2. mixed notation, 3. mixed notation and output the sum. Use IN - read only variable; OUT - for storing output.
Write sql code to test script. System must ask user to input the data.
Nº del proyecto: #19142414
Sobre el proyecto
Adjudicado a:
I'm Good With using SQL , Access , Oracle DB , with c# programming contact me and we will discuss the details
13 freelancers están ofertando un promedio de $96 por este trabajo
Hi I'm an expert in databases. I'm sure that I can easily do this project. We can have a about it. Thanks..
Hi, I am a SQL server expert with 7+ years of experience. I can help you write the storedprocedures you have mentioned. I can complete the same today itself. Looking forward to connect with you and take it forwa Más
I am a database expert having experience of 3 years. I will complete your work as per the requirements and deliver it on time.
I have a great experience with SQL , I can help u with that , don't hesitate to contact me
i have enough experience working with PL/SQL to make this. I can assure quality and speed in the task
I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB desi Más
I already have a code suitable for your requirement for tasks 1,3,4. but can you please be clear about structure of table you want to fetch the information for the 2nd task mentioned above project.
Dear Sender, Thanks for the requirement. I have profound experience in sql , pl/sql , Oracle forms and reports 11g, Oracle EBS 11i, R12 on GL, AP, AR, FA and in SCM OM, PO, INV etc. and work on various projects on same Más