Oracle

sql using oracle

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2009

Posts: 6

Reputation: scuzzo is an unknown quantity at this point

Solved Threads: 0

scuzzo

Offline

Newbie Poster

sql using oracle

Sep 30th, 2009

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT last,first FROM customer WHILE credit_limit>799;
select last,first from customer while credit_limit>799;

Give the order number for every order placed by customer number 124 on 9/05/1998.

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT order_number FROM orders WHILE order_date='05-SEP-02';
select order_number from orders while order_date='05-SEP-02';

List the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12.

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT customer_number,last,first FROM customer WHILE slsrep_number=3 AND slsrep_number=12;
select customer_number,last,first from customer while slsrep_number=3 and slsrep_number=12;

List the part number and part description for every part that is not in item class HW.

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT part_number,part_description FROM part WHEN it <>'HW';
select part_number,part_description from part when it <>'HW';

List the part number and part description for every part that has between 100 and 200 units on hand.

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT part_number,part_description FROM part WHERE units_on_hand>99 AND units_on_hand<201
select part_number,part_description from part where units_on_hand>99 and units_on_hand<201

From here I'm lost can anyone give me some help. Please.
List the name of all customers who has a balance less than their credit limit.

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT last,first FROM customer WHERE balance<credit_limit;
select last,first from customer where balance<credit_limit;

For every order, list the order number, order date, part number, part description, and number of units ordered.

Find the customer number, last name nad first name for every customer who currently has an order on file for an iron.

List the part description, part number, order number and order date for every order placed by Mary Nelson that does not contain an order line for a treadmill. You must use the set operation of minus to do this problem.

List the order number and order date for every order that was placed by Mary Nelson or that contains an order line for an iron. You must use the set operation of union to do this problem.

List the order number and order date for every order that was placed by Mary Nelson and contains an order line for an iron. You must use the set operation of intersection on this problem.

Last edited by peter_budo; Oct 1st, 2009 at 5:39 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.