1.
CREATE TABLE Customers (CustomerID NUMBER(1) PRIMARY KEY, CustomerName
VARCHAR2(35), ContactName VARCHAR2(20), Address VARCHAR2(30), City VARCHAR2(15),
PostalCode VARCHAR2(10), Country VARCHAR2(10));
2. INSERT INTO Customers VALUES (1,'Alfreds Futterkiste','Maria Anders', 'Obere Str. 57',
'Berlin', '12209', 'Germany' );
3. INSERT INTO Customers VALUES (2,'Ana Trujillo Emparedados y helados','Ana Trujillo', 'Avda.
de la Constitucion 2222', 'Mexico D.F.', '05021', 'Mexico' );
4. INSERT INTO Customers VALUES (3,'Antonio Moreno Taqueria','Antonio Moreno', 'Mataderos
2312', 'Mexico D.F.', '05023', 'Mexico' );
5. INSERT INTO Customers VALUES (4,'Around the Horn','Thomas Hardy', '120 Hanover Sq.',
'London', 'WA1 1DP', 'UK' );
6. INSERT INTO Customers VALUES (5,'Berglunds snabbkop','Christina Berglund', 'Berguvsvagen
8', 'Lulea', 'S-958 22', 'Sweden' );
2)
1. INSERT INTO Customers VALUES (6,'Nilesh Kumar','NileshKr', 'Shree kishan BHagat Ln',
'Howrah', '711101', 'India' );
2. SELECT * FROM Customers;
3)
1. CREATE TABLE Cust_BackUp (CustomerID NUMBER(1) PRIMARY KEY, CustomerName
VARCHAR2(35), ContactName VARCHAR2(20), Address VARCHAR2(30), City VARCHAR2(15),
PostalCode VARCHAR2(10), Country VARCHAR2(10));
2. INSERT INTO Cust_BackUp SELECT * FROM Customers;
3. SELECT * FROM Cust_BackUp;
4)
1. DELETE FROM Customers WHERE city ='Berlin' OR Country= 'UK';
2. SELECT * FROM Customers;
5)
1. SELECT CustomerName, Address FROM Customers WHERE Country NOT IN ('UK','Mexico')
ORDER BY City;
6)
1. SELECT COUNT(DISTINCT Country) FROM Customers;
7)
1. SELECT * FROM Customers ORDER BY Country, CustomerName DESC;
2. UPDATE Customers SET City = 'Tijuana' WHERE CustomerID IN ( SELECT CustomerID FROM
Customers WHERE Country = 'Mexico' AND ContactName <> 'Antonio Moreno');
3. SQL> SELECT * FROM Customers;