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
Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Using LOCK TABLE You use the LOCK TABLE statement to lock the whole database tables in the specified lock mode so that you can share or deny the access to them. For illustrati

%TYPE: This attribute gives the datatype of a formerly declared collection, cursor variable, object, field, record, database column, or variable. Datatype: This is simply

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

GOTO Statement   The GOTO statement branches categorically to a block label or statement label. The label should be exclusive within its scope and should precede a PL/SQL bloc

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a