Part 1: Using OES4 database, redo the following two queries (you did them in assignment 4) with PL/SQL: 1. List number of orders for each branch with their total purchase (SUBTOTAL), total shipping charge, total tax, and total purchases (there are 15 branches) BRANCH#, #_ORDERS, TOTAL PURCHAES, TOTAL SHIPPING CHARGES, TOTAL TAXES, TOTAL OVERALL PURCHASE (3) Note: Use RPAD or LPAD to develop your report 2. List number of employees with their total sales (SUBTOTAL), total shipping charge, total tax, and overall total SALESS. EMPLOYEE_NO, TOTAL SALES, TOTAL SHIPPING CHARGES, TOTAL TAXES, TOTAL OVERALL SALES (3) 3. List all product categories and number of products sold for each category PRODUCT_CATEGORY QTY_SOLD

A: In the given question  SQL stand for structured  query  language.

A: Software programs known as database management systems make it easier to create, organize, retrieve,…

A: Null functions in Oracle SQL are essential for controlling and modifying null values in database…

A: Procedural Language/Structured Query Language, or PL/SQL, is a potent SQL extension meant for…

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

A: Importance of SQL-92 User has option to set New SQL-92 instead of original SQL-89 in Access 2010,…

A: In SQL, the execution sequence of clauses is vital for comprehending how a query is processed. Each…

A: 1) Database functions in SQL are pre-defined operations that allow you to perform various tasks on…

A: get PL/SQL language to operate correctly in MySQL

A: Differences between Oracle PL/SQL programming functions and procedures   S.N.   function…

A: Language for Data Manipulation (DML): These SQL statements work with the database's data to…