Solve the business problems using sql, PL-SQL Programming

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server. Output is not required.

1. Display full details for the creditor and purchase order where the order was processed by employee 17 and the word video or the word audio appears in the creditor name.

2. Display the post code and the total number of purchase orders placed with creditors in that post code. Display details for post codes with more than ten orders only.

3. Using a set operator, display the creditor number of all creditors in post code 2220 who have never been paid more than 4000 dollars in a single payment.

4. Display full details for the creditor/s who has received the single largest payment

Posted Date: 3/2/2013 2:17:43 AM | Location : United States







Related Discussions:- Solve the business problems using sql, Assignment Help, Ask Question on Solve the business problems using sql, Get Answer, Expert's Help, Solve the business problems using sql Discussions

Write discussion on Solve the business problems using sql
Your posts are moderated
Related Questions
Use of COUNT in SQL It describes and discusses various general methods of expressing constraints, eventually noting that support for "=" with relation operands is sufficient f

Processing Transactions This part describes how to do the transaction processing. You learn the fundamental techniques that safeguard the consistency of your database, involvin

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Positional Notation The first procedure call uses the positional notation. The PL/SQL compiler relates the first actual parameter, account, with the first proper parameter, ac

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Definition of CROSS JOIN - SQL Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then: Note: Here T denotes Table

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Consider the schema for FreeChecking Bank, that we designed given below. Translate the given ER schema into SQL CREATE TABLE statements (indicating primary key, unique and foreign

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst