Practical Practice -2

Oracle Practice

Overview

Practice -2

SOLUTION


create table infant
(
item_code number primary key,
item varchar2(100) not null,
DatePurchase date,
UnitPrice number,
Discount number);

SOLUTION


insert into infant values(101,'Frock','23-Jan-2016',700,10);
insert into infant values(102,'Cot','23-Sep-2015',5000,25);
insert into infant values(103,'Soft Toy','17-Jun-2016',800,10);
insert into infant values(104,'Baby Socks','16-Oct-2014',100,7);
insert into infant values(105,'Baby Suit','20-Sep-2015',500,5);

SOLUTION 1

SELECT Item, UnitPrice FROM Infant WHERE UnitPrice < 800 AND Discount > 5;

SOLUTION 2

SELECT COUNT(*) AS NumberOfItems FROM Infant WHERE Discount > 10;

SOLUTION 3

SELECT Item Code, UnitPrice FROM Infant ORDER BY UnitPrice DESC;

SOLUTION 4

UPDATE Infant SET UnitPrice = UnitPrice * 1.10;

SOLUTION 5

SELECT MAX(UnitPrice) AS HighestUnitPrice FROM Infant;

SOLUTION 6

SELECT Item FROM Infant WHERE Item LIKE '%Baby%';

Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Comment *
Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Practical Practice for Oracle – 2

Practical Practice -2

Oracle Practice

Overview

Practice -2

SOLUTION

create table infant ( item_code number primary key, item varchar2(100) not null, DatePurchase date, UnitPrice number, Discount number);

SOLUTION

SOLUTION 1

SELECT Item, UnitPrice FROM Infant WHERE UnitPrice < 800 AND Discount > 5;

SOLUTION 2

**SELECT COUNT(*) AS NumberOfItems FROM Infant WHERE Discount > 10;**

SOLUTION 3

SELECT Item Code, UnitPrice FROM Infant ORDER BY UnitPrice DESC;

SOLUTION 4

**UPDATE Infant SET UnitPrice = UnitPrice * 1.10;**

SOLUTION 5

SELECT MAX(UnitPrice) AS HighestUnitPrice FROM Infant;

SOLUTION 6

SELECT Item FROM Infant WHERE Item LIKE '%Baby%';

Leave a Reply Cancel reply

sign up!