FOR FREE CONTENT

Employee (Employee_id, Name, Designation, Branch)

a)     Alter the table by adding a column salary.

b)     Alter the table by modifying the column Name, Name to Employee_name

c)     Describe the table Employee.

d)     Display the names of employees located at Kolkata.

e)     Delete the second row from the table.

f)      Sort the table on employee_id in descending order.

g)     Display the details of whose name’s second letter is ‘a’ and located at Kolkata

CREATE TABLES AND INSERT VALUES

CREATE Table EMPLOYEE:

CREATE TABLE EMPLOYEE (

Employee_id

NUMBER(5) PRIMARY KEY,

Name VARCHAR(50), Designation VARCHAR(5),

Branch VARCHAR(5)); 

Table EMPLOYEE is created.

Insert the values in the table "EMPLOYEE" :

INSERT INTO Employee VALUES(110, 'RAM', ‘HOD’,’KOLKATA’)

INSERT INTO Employee VALUES(141, 'SHYAM', ‘MANAGER’,’RAJASTHAN’)

INSERT INTO Employee VALUES(109, 'MADHU', ‘TYPIST’,’PUNE’)

INSERT INTO Employee VALUES(167, 'BIMAL', ‘HOD’,’MUMBAI’)

INSERT INTO Employee VALUES(102, 'KAMAL', ‘TYPIST’,’KOLKATA’);

Output:

5 rows created