pl/sql block

Medium Other 🔀 If-Else Statements
👁️ 1 views 👤 By Super Admin 📅 Jan 31, 2026

❓ Question

Q.1(A) Create following table with proper constraints, primary key. Insert at least 10 records in each table. 1.Custmast(custID, cname,city,phoneno) 2.Billmast(billno,custID, bill_date, bill_amt) Q.1(B) Write a PL/SQL block to give 20% discount on bill amount more than Rs. 3200. Else give 5% discount and display the details.

💻 Submit Your Solution

Please login to submit your solution and earn points.

Login Now

🔗 Related Programs