Answer Happy

Create a PL/SQL program that takes any product brand name as an input parameter and displays all the products related to the brand. Use cursor with parameter. The cursor has to take brand name as a parameter to fetch the products.
Database Tables Nizwa Store sells bread, cookies, cakes, pastries and chocolates. It has many branches across Oman. They are using Store Management Software solution to manage their sales details. This software solution is using STORE database schema to record the stores, products, salesman and sales details. Use this schema and write all the questions. SQL> select * from products; SQL> select * from store; STOREID CITY REGION PRODUCTID PRODUCTNAME BRAND 1 Musketeers 2 5 Star 3 Aero 4 Aero Mint 5 Bounty 6 Galaxy 7 Moro Mars Cadbury Nestle Nestle Mars Mars Cadbury 10 Nizwa 20 Ibri 30 Ibra 40 Muscat 50 Sohar 60 Salalah Ad Dhahiliyah Ad Dhahirah Ash Sharqiyah Muscat Al Batinah Dhofar SQL> select * from sales_details; TRANS_ID STOREID PRODUCTID COST SALES_AMOUNT PROFIT 1 2 3 4 5 6 7 8 10 20 30 40 50 60 40 20 w WNNN 1 1 2 2 2 3 3 3 3 3 2 2 2 4 4 4 3.5 3.5 3.6 5 3.5 6 5 4.5 ло о Φ Φ Φ Φ Φ Φ SQL> select * from salesman; SALESMANID STOREID NAME JOING_DATE SALARY 101 201 301 401 501 601 10 Nizar 20 Ibrahim 10 Izkaq 40 Munir 50 Sulaiman 60 Salman 12-Jan-2016 11-Feb-2009 02-Jan-2011 24-Jan-2014 05-Mar-2016 25-Apr-2014 800 1200 1100 900 80e 900