Iam supposed to get the table std from another database and insert into the
present database using the dblink but I want the Pguid coulmn data too when both notes_id matches.
execute immediate ' insert into std(std_id,std_name,pguid)
where std.notes_id = notes.notes_id
but when i do this, Its only inserting the ones when notes_id condition is met,
but I want to insert all the records into the 9.0 student table and if it got any pguid, get it from the notes table and insert it and if it does not have any pguid, just leave the pguid column as null ?