السلام عليكم ورحمة الله وبركاته ممكن مساعدة في بعض الاسئلة

عندي جدولين وهم

create table Customer (Cust_ID number,
cust_FNAme varchar(25),
cust_LNAme varchar(25),
cust_Address varchar(25),
cust_phone_NO number(8),
cust_pBox varchar(15),
cust_AccountNo varchar2(16),
cONSTRAINT PK_cust PRIMARY KEY( Cust_ID,Cust_AccountNo));
create table bill ( bill_ID number,
Cust_ID number,
cust_AccountNo varchar2(16),
Current_charge_Date Date,
Part_Due number(7,3),
Total_Due number(7,3),
Amount_paid number(7,3),
cONSTRAINT PK_bill PRIMARY KEY(bill_ID),
CONSTRAINT FK_cust_Acc FOREIGN KEY(Cust_ID,cust_AccountNo )
REFERENCES Customer(Cust_ID,cust_AccountNo )) ;


اريد اعرف كيف ممكن اطبق الاسئلة التالية

1. Write an anonymous block of PL/SQL program using if condition to display the account holders who pay less than 10 $.
2. Write an anonymous block of PL/SQL program using nested if condition to count the number of account holders paid less than 10$, between 11 -20 $, 21-30 $ and 31$ and above.
3. Write an anonymous block of PL/SQL program using while loop to print the account holders who are all from Muscat.
4. Write a cursor program of your choice for the above tables and explain the cursor types and its advantages.
   

1. Write an anonymous block of PL/SQL program using if condition to display the account holders who pay less than 10 $.
2. Write an anonymous block of PL/SQL program using nested if condition to count the number of account holders paid less than 10$, between 11 -20 $, 21-30 $ and 31$ and above.
3. Write an anonymous block of PL/SQL program using while loop to print the account holders who are all from Muscat.
4. Write a cursor program of your choice for the above tables and explain the cursor types and its advantages.
   

1. Write an anonymous block of PL/SQL program using if condition to display the account holders who pay less than 10 $.
2. Write an anonymous block of PL/SQL program using nested if condition to count the number of account holders paid less than 10$, between 11 -20 $, 21-30 $ and 31$ and above.
3. Write an anonymous block of PL/SQL program using while loop to print the account holders who are all from Muscat.
4. Write a cursor program of your choice for the above tables and explain the cursor types and its advantages.
   

لدي نفس الاسايمنت
بامكانك استخدام جدول واحد اسهل يكون لك :]