Subject

Concepts of Relational Database Management System(RDBMS)

Open Topic Tutorial View

Student Questions

Primary View

Question Bank

Student ko sidha saare mapped questions yahin milenge. Neeche filters use karke MCQ, theory, practical ya marks-wise alag dekh sakte ho.

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)