Add a new column to a table and insert values

[aditi14]

For add new col you need alter command
SQL>alter table emp add (email varchar2(30));
For insert the value in this col according condition
SQL>update emp set email='gmail' where name='scott';