Basic DDL

Queries

1. Display all records in the EMP table.

2. Display all employees who are working as managers.

3. Display the detail of employee with employee no. 7369.

4. Display all employees who joined on 1st May,1981.

5. Display all employees with salary greater than Rs.1500/-.

6. Display all employees who are not getting any commission.

7. Display all employees whose names are starting with “A”.

8. Add a new attribute Phone No.

9. Change the data type of attribute Job from char to varchar2.

10. Remove the attribute Phone No. from the table.

11. Describe the tables emp and dept.

12. Display lexicographically smallest and largest employee name starting with letter 'A'.