CREATE TABLE tbl1

(col1 numeric(10,2),
col2 varchar(50),
primary key(col1));

1 val1
2 val2

insert into tbl1(col1,col2)

values (1 , 'val1');

insert into tbl1

values (2 , 'val2');

desc tbl1;

drop table supplier;

drop table employees;
drop table product;
drop table customer;
drop table sale;

desc supplier;
create table supplier
(SupplierID number(10),
SupplierName Varchar(50),
Township varchar(50),
City varchar(20),
Region varchar(20),
PostalCode number(10),
Primary key (SupplierID));
select * from supplier;
delete from supplier where supplierid=1001;

INSERT INTO SUPPLIER(SupplierID,SupplierName,Township,City,Region,PostalCode)

VALUES
(1001, 'Joles', 'Ahlone','Yangon', 'Yangon', '11121');

INSERT INTO SUPPLIER VALUES

(1002, 'Adam', 'Insein','Yangon', 'Yangon', '11012');
INSERT INTO SUPPLIER VALUES
(1003, 'Soe Moe', 'Botahtaung','Yangon', 'Yangon', '11162');
INSERT INTO SUPPLIER VALUES
(1004, 'Smith', 'Dagon Myothit (North)','Yangon', 'Yangon', '11421');
INSERT INTO SUPPLIER VALUES
(1005, 'Smith', 'Mayangone','Yangon', 'Yangon', '11061');

INSERT INTO SUPPLIER VALUES

(1006, 'Wai Phyo', 'Amarapura ','Mandalay','Mandalay', '05061');
INSERT INTO SUPPLIER VALUES
(1007, 'Swe Zin Aung', 'Aungmyaethazan','Mandalay','Mandalay', '05011');
INSERT INTO SUPPLIER VALUES
(1008, 'James', 'Chanayethazan','Mandalay','Mandalay', '05024');

INSERT INTO SUPPLIER VALUES

(1009, 'Khun Htoo', 'Tarkaw', 'Lashio ','Shan', '06301');
INSERT INTO SUPPLIER VALUES
(1010, 'Nang Mo Phaung', 'Nantpaung', 'Muse','Shan', '06402');
INSERT INTO SUPPLIER VALUES
(1011, 'James', 'Nanpan', 'Muse','Shan', '06404');

select * from supplier;

CREATE TABLE EMPLOYEES

( EMPLOYEE_ID VARCHAR2(20 BYTE),
LAST_NAME VARCHAR2(50 BYTE),
EMAIL VARCHAR2(40 BYTE),
JOB_ID VARCHAR2(20 BYTE),
HIRE_DATE DATE,
SALARY NUMBER(10),
PRIMARY KEY (EMPLOYEE_ID));

INSERT INTO EMPLOYEES VALUES

('E0001', 'Nang Lao', 'lao@gmail.com','J001','25-Nov-2009',500000);
INSERT INTO EMPLOYEES VALUES
('E0002', 'Khun Kyaw Kyaw', 'kyawkyaw@gmail.com','J002','20-DEC-2008',450000);
INSERT INTO EMPLOYEES VALUES
('E0003', 'U Soe Tun', 'soetun@gmail.com','J003','20-Aug-2008',300000);
INSERT INTO EMPLOYEES VALUES
('E0004', 'Nang Mo Hom', 'mohom@gmail.com','J003','15-Jan-2009',600000);
INSERT INTO EMPLOYEES VALUES
('E0005', 'Sai Sam', 'saisam@gmail.com','J002','10-DEC-2008',400000);
INSERT INTO EMPLOYEES VALUES
('E0006', 'U Soe Moe Aung', 'soemoeaung@gmail.com','J003','12-Aug-2010',300000);
CREATE TABLE Product
(ProductID VARCHAR2(20),
ProductName VARCHAR2(50),
Price NUMBER(10),
PRIMARY KEY (ProductID));

INSERT INTO Product

VALUES ('P0001','Addidas Shoe 22', 75000);
INSERT INTO Product
VALUES ('P0002','NIKE Shoe 110', 45000);
INSERT INTO Product
VALUES ('P0003','ADDA Shoe_Men 12', 15000);
INSERT INTO Product
VALUES ('P0004','New Balance 110', 40000);
INSERT INTO Product
VALUES ('P0005','Reebok Shoe 22', 35000);
INSERT INTO Product
VALUES ('P0006','FILA Shoe 001', 65000);
INSERT INTO Product
VALUES ('P0007','Converse Shoe 2001', 75000);
INSERT INTO Product
VALUES ('P0008', 'Dr. Martens Shoe 22', 85000);
INSERT INTO Product
VALUES ('P0009','TOMs Shoe 22', 70000);
INSERT INTO Product
VALUES ('P0010','ANTA Sports Shoe 22', 25000);

INSERT ALL
INTO Product
VALUES ('P0011','Hush Puppies Shoe 221', 90000)
INTO Product
VALUES ('P0012','Kappa Shoe 112', 86000)
INTO Product
VALUES ('P0013','Puma Shoe 110', 105000)
select * from dual;

CREATE TABLE Customer

(CustomerID VARCHAR2(20),
CustomerName VARCHAR(50),
Address VARCHAR(50),
PhoneNumber VARCHAR(12),
PRIMARY KEY(CustomerID));
INSERT INTO CUSTOMER
VALUES ('C0001', 'Aung Soe', '87,Ma Yan Gone, Yangon', '0944456655');

INSERT INTO CUSTOMER

VALUES ('C0002', 'Aye Su Kyi', '72,Myaynigone, Yangon', '095665577');

INSERT INTO CUSTOMER

VALUES ('C0003', 'Aung Aung Oo', 'BawgaThiri, NaypyiTaw', '097272777');

INSERT INTO CUSTOMER

VALUES ('C0004', 'Soe Moe Oo', 'Wa Pyar, Taungyi', '099779992');

select * from customer;

CREATE TABLE Sale

(SaleID varchar(20) not null,
CustomerID varchar(20),
ProductID varchar(20),
DateSold Date,
Notes varchar(20),
PRIMARY KEY(SaleID),
FOREIGN KEY (ProductID) REFERENCES Product,
FOREIGN KEY (CustomerID) REFERENCES Customer);

INSERT INTO Sale

VALUES ('S0001','C0004','P0001','20-DEC-2008','');
INSERT INTO Sale
VALUES ('S0003','C0002','P0006','5-OCT-2009','25% discount');
INSERT INTO Sale
VALUES ('S0004','C0003','P0007','20-May-2009','15% discount');
INSERT INTO Sale
VALUES ('S0005','C0003','P0009','30-OCT-2009','20% discount');

INSERT INTO Sale

VALUES ('S0006','C0004','P0002','29-JUN-2010','10% discount');

INSERT INTO Sale

VALUES ('S0007','C0001','P0006','3-July-2010','30% discount');
INSERT INTO Sale
VALUES ('S0008','C0003','P0002','30-Aug-2009','15% discount');
INSERT INTO Sale
VALUES ('S0009','C0001','P0011','13-OCT-2010','');

INSERT INTO Sale

VALUES ('S0010','C0002','P0011','17-OCT-2010','5% discount');

INSERT INTO Sale

VALUES ('S0011','C0003','P0001','19-OCT-2010','10% discount');

INSERT INTO Sale

VALUES ('S0012','C0002','P0008','22-OCT-2010','15% discount');

select * from sale;

select * from employees;
select * from supplier;
select * from customer;
select * from product;

SELECT SUPPLIERNAME FROM SUPPLIER;

SELECT SUPPLIERNAME,Township FROM SUPPLIER;
SELECT SUPPLIERID,SUPPLIERNAME,Township FROM SUPPLIER;

SELECT SUPPLIERID,SUPPLIERNAME,City FROM SUPPLIER WHERE CITY='Yangon';

SELECT * FROM SUPPLIER WHERE SUPPLIERNAME='Joles';

SELECT employee_id, last_name, salary

FROM employees
WHERE salary = 500000;

SELECT employee_id, last_name, salary

FROM employees
WHERE last_name <> 'U Soe Tun';

SELECT employee_id, last_name, salary

FROM employees
WHERE salary > 350000;

SELECT employee_id, last_name, salary

FROM employees
WHERE salary > =300000;

SELECT employee_id, last_name, salary

FROM employees
WHERE 300000=Salary;