Show Bid Request
Oracle 8i PL/SQL
Bid Request Id: 35214
|
|
|
|
Posted by: |
MVPCapper (1 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Above Average - 33.33%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Nov 13, 2002
10:24:59 AM EDT
|
|
Bidding Closes: |
Nov 15, 2002
9:00:39 AM EDT
|
|
Viewed (by coders): |
107 times
|
|
Deadline: |
11/16/2002
TIME EXPIRED
|
|
|
|
|
Description:
1. Write a PL/SQL program in Oracle 8i that uses and implicit cursor to display the project name, client name, and project manager first and last name for P_ID 5 in the Software Experts database. Include the WHEN OTHERS exception handler. Format the program output as shown in http://members.aol.com/Jojowagertalk/1.gif Use variable values rather then hard-coded values wherever possible in the DBMS_OUTPUT function. Spool to text file and save as 4B3.txt
2. Write a PL/SQL program in Oracle 8i that displays the full name and address of Clearwater Traders customer Alissa Chang and then summarizes the details of all of her orders, as shown in http://members.aol.com/Jojowagertalk/2.gif Use and implicit cursor to retrieve and display the order information. Spool to text file and save as 4B7.txt
Deliverables:
1. Two text files with completed assignment
Platform:
Oracle8i for Windows
Must be 100% finished and received by buyer on:
Nov 16, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Special Conditions / Other:
Must b
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$15 (USD)
|
Nov 13, 2002
11:35:01 AM EDT
|
7.81
(Very Good)
|
|
|
I have over six years of experience in programming with PL/SQL and should be able to take care of this easily. Could you please send a copy of the database table layouts for the tables needed in the assignment? I will not be able to complete this assignment without this information. If accepted, I would probably have this project done by tomorrow at the latest.
|
|
|
|
|
|
|