faizanahmad

I was trying to add a new field in an Oracle DB table using this script: alter table TABLENAME add FIELDNAME char(1) not null default '0' ;

I had to update value from a staging table( this might be a temp table ) into another database table. Here is how I did it using a inner join in the…