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
set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Example of GROUPBY Operator Example: How many students sat each exam, using GROUP BY, NATURAL LEFT JOIN, and COALESCE SELECT CourseId, COALESCE (n, 0) AS n FROM COURS

Closing a Cursor The CLOSE statements disable the cursor, and the result set becomes undefined. An illustration of the CLOSE statement as shown: CLOSE c1;

Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

SQLs counterpart of the key words: The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ