pl/sql block
🔀 If-Else Statements
Other
Medium
🔄 Converted
Asked by Jariwala Jil
•
Jan 31, 2026 at 11:23
•
Subject: Concepts of Relational Database Management System(RDBMS)
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.
💬 0 Comments
🔄 This question has been converted to a program
View Program →Want to help? Login to submit your solution!
💬 Comments (0)
Login to post comments
No comments yet
Be the first to comment!