Create SQL statements based on table fields values

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Senen (spaul_at_amkor.com)
Date: 02/18/04


Date: Tue, 17 Feb 2004 22:43:03 -0800

I need to create a program that will read a table and
translate it to SQL statements. For example, a table has
the following contents:

  Source Destination Column
  table_a table_a1 column_1
  table_b table_b1 column_2
  table_c table_c1 column_3
  ...

With this table I will be able to translate it to SQL
statement for execution:

  select column_1 into table_a1 from table_a
  select column_2 into table_b1 from table_b
  select column_3 into table_c1 from table_c
  ...

Thanks in advance.