create table myemp as
select EMP_ID, FIRST_NAME, LAST_NAME,cast(null as number(10)) as "CAST_ID", EMAIL ,PHONE_NUMBER, HIRE_DATE, JOB_ID ,SALARY ,COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID ,C_ID, GENDER, AGE from My_employees;
all the columns have values except "cast_id" column because this mentioned as null while creating the "myemp" table.
Now I need to insert data in Cast_id column in "myemp" table from another table "cast".
The "cast" table has only one column "cast_id".
There is no common column for these two tables "myemp" and "cast" to insert data.
Insert into myemp (cast_id) select cast_id from cast;
When i was trying to insert those values new rows are created for this values.
but i want to insert those values in the existing rows.
Please guide me to do this..