إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

مساعدة : Write a PL/SQL block to print the 2nd maximum bill amount


لا توجد ردود على هذا الموضوع

#1 AL-AMRI

AL-AMRI

    عضو

  • الأعضــاء
  • 8 مشاركة

تاريخ المشاركة 05 May 2009 - 03:20 PM

Write a PL/SQL block to print the 2nd maximum bill amount from CUSTOMERS.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Write a PL/SQL procedure called amount to retrieve the bill amount of the customer whose customer number will be passed as argument in this procedure. Then write a PL/SQL block to accept the customer number and print the bill amount of this customer using the amount procedure. Use appropriate exceptions in the procedure amount.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>\
Write a PL/SQL function called maxamt to retrieve the maximum bill amount of all customers whose customer number will be passed as argument in this function. Then write a PL/SQL block display the maximum bill amount using the maxsal function.