Add a new column to a table and insert values

[kalayama]

It is simple task as long as your new column allows NULLs.
Take a back up of existing table and then go on to add the column.

select * intoo emp_backup from emp.

ALTER TABLE EMP
ADD emp_email varchar2(40);

This will add the column emp_email to emp table.

Now to add a value to this column, you should use UPDATE statement. Simple as that.

Cheers!
Kalayama

[denniscodd]

It is simple task as long as your new column allows NULLs.
Take a back up of existing table and then go on to add the column.

select * intoo emp_backup from emp.

ALTER TABLE EMP
ADD emp_email varchar2(40);

This will add the column emp_email to emp table.

Now to add a value to this column, you should use UPDATE statement. Simple as that.

Cheers!
Kalayama

what is table mutation error and what is the occation it will happen

[krishnaindia2007]

>>what is table mutation error and what is the occation it will happen

Follow the link