Pr.Pg Next Pg

Changing a Table Definition/ adding new column in the Table tutorials

 

  • Oracle SQL Developer makes it very easy to make changes to database objects. In this topic, we will add a column called COUNTRY to the SUPPLIER table, previously we have just created the SUPPLIER table. Perform the following steps:

  • Since we know that how to start the SQL Developer.

1. In the HRADMIN_conn connection navigator, SELECT the SUPPLIER table.

 

 

2. Right-click on SUPPLIER table, select Column then Add...

 


 

3. Enter COUNTRY, select VARCHAR2 for the Data Type (from the drop down list), set the Scale to 30. Click Apply.

 

4. The confirmation verifies that a column has been added. Click OK.

 

 

5. Expand the SUPPLIER table to review the updates.

 

 

  • Hence a new column COUNTRY is added in to the SUPPLIER table.

Pr.Pg border                                              Next Pg