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
Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Define basic operators of relational algebra with an example each

Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l