Student Questions

Second View

All Questions Explorer

Current topic/subtopic view ke saath ab ek combined explorer bhi hai jahan saare mapped questions ek sath milenge.

Total
0
MCQ
0
Theory
0
Practical
0
No mapped questions found for this subject.

pl/sql block

Asked by Jariwala Jil on Jan 31, 2026

🔄 Converted

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.

🔀 If-Else Statements Other Medium
💬 0 comments 👍 0 upvotes

pl/sql block

Asked by Jariwala Jil on Jan 31, 2026

🔄 Converted

(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)

🔀 If-Else Statements Other Medium
💬 0 comments 👍 0 upvotes
Showing 2 question(s)