Orcal use sql create table

 **Creating table of sql**

create table customer (customerid int,customerName varchar2(10),contctName varchar2(10),address varchar2(10),city varchar2(10),postalcode int,country varchar2(10));

insert into customer values(1,'alfreds','maria','obere','berlin',12209,'germany');

insert into customer values(2,'ana','wistom','avda','maxico',1245,'mexico');

insert into customer values(3,'antonio','joph','mataden','maxico',1245,'mexico');

insert into customer values(4,'horn','rane','honas','london',1409,'uk');

insert into customer values(5,'bergul','mofin','bergun','lulea',1502,'sweden');

insert into customer values(6,'baunder','maje','foston','mannheim',1600,'germany');

insert into customer values(7,'tim','lafin','konom','strasbourg',1800,'france');

insert into customer values(8,'gilm','toson','jonsom','madrid',1400,'spain');

**NOT oprator of sql**

select*from customer

where not country='germany';

**AND/OR both oprator of sql **

select*from customer

where country='germany'and(city='berlin'or city='munchen');

**OR oprator of sql**

select*from customer

where city='berlin'or city='munchen';

**AND oprator of sql**

select*from customer

where country='germany'and city='berlin';