Explore programs, questions, notes, and assignments for this subject
(A) Create following table with proper constraints, primary key. Insert at least 10 records in each table. 1.Custmast(custID, cname,city,phoneno) ...
Q.1(A) Create following table with proper constraints, primary key. Insert at least 10 records in each table. 1.Custmast(custID, cname,city,phonen...
Asked by Jariwala Jil on Jan 31, 2026
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.
Asked by Jariwala Jil on Jan 31, 2026
(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)
Posted by Super Admin on Jan 03, 2026
JOIN queries (INNER, LEFT),Subquery example