Using Oracle SQL

Question 1 CREATE TABLE called supplier with the following fields . supplier_idnumeric(10) - > Primary key with constraint name supplier, name varchar2(50) - >unique name contact name varchar2(50) city varchar2(10) Region -> should accept only ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E') 1. Insert 5 records. Insert records based on the below questions. 2. Display the details of the supplier who comes from Torontoand their supplier id 500; 3. Add phone number in the supplier table using DDL command 4. Write a sql command to make city as unused column 5. Delete the unused column in the supplier table 6. Rename table SUPPLIER -> SUPPLIER CONTACT 7. Write a sql command to delete all the records in the supplier table. 8. Write a sql command to Retrieve the deleted table 9. Write a sql command to permanently delete the table , so that it is not moved to recyclebin |