ضروري وفي اشد حاجتي في Pl/sql

[small baby2]

سلام لكل الاعضاء
لقد اجبت عن جميع الاسئله التي في كتاب الاوراكل 10 وفي شابتر اربعه ولكن عندما وصلت الى القسم بي لم استطع ان اكمل فارجو المساعده ضروري لان لايوجد الوقت لتاخير اكثر
اني اختكم وارجو ان تنقذوني

انتظر الرد

1. Create a PL/SQL program block that retrieves each customer from the customer table and create al list that display each customers name, address, and daytime phone number on a single line. Print heading at the beginning of the list identifying it as the "Clearwater Traders Mailing List".




2. Create a PL/SQL program block that identifies each customer's name and the total amount owed by each customer .Also display the total the amount owed by all customer as the final line of output.




3. create a PL/SQL program block that display each order and the item on that order .




4. The management of Clearwater Traders is considering implementing a new discount policy .if the total order is more than $100,the customer receives a 10%discount ; if it totals more than $200 ,a 20%discount is applied .Create a PL/SQL block that calculates the total amount due for each order before any discount is applied and then revised amount due with the appropriate discount applied .include only the order ID ,original amount ,and discount amount in the results.




5. create a PL/SQL block that can be used to retrieve the description and price of inventory item based on its ID. include the appropriate exception handling to display a massage if the item is not found .

[sameh bakkar]

رجاء ارسال رقم الفصل و رقم كل سؤال داخل كتاب اوراكل حتى استطيع الرد بسرعه ..