SQL & PL/SQL

Hi all,

Need to insert data into sample_table1,sample_table2 from xxc_source_table table

create table xxc_source_table(DESCRIPTION varchar2(10));

insert table  xxc_source_table values('A201.ABC.4084.GR');

create table sample_table1(col_1 varchar2(10),col_2 varchar2(10),col_3 varchar2(10),col_4 varchar2(10));

create table sample_table2(col_1 varchar2(10),col_2 varchar2(10),col_3 varchar2(10),col_4 varchar2(10),moved_flag varchar2(2));

col_1=A201

col_2=ABC

col_3=4084

col_4=GR

Note: Insert the data into the sample_table1  col_1,col_3,col_4 from the xxc_source_table

      2) if the coming data(form  xxc_source_table ) are is exist in the sample_table2, then set the moved_flag as Y in this column

      3) xxc_source_table has 17000 rows

Thank you.

Message was edited by: Rajesh123 please do not consider cross line message