Create SQL statements based on table fields values
From: Senen (spaul_at_amkor.com)
Date: 02/18/04
- Next message: David Portas: "Re: UPDATE statement"
- Previous message: Roji. P. Thomas: "Re: SQL statement with 2 tables"
- Next in thread: Roji. P. Thomas: "Re: Create SQL statements based on table fields values"
- Reply: Roji. P. Thomas: "Re: Create SQL statements based on table fields values"
- Reply: Joe Celko: "Re: Create SQL statements based on table fields values"
- Reply: Anith Sen: "Re: Create SQL statements based on table fields values"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: David Portas: "Re: UPDATE statement"
- Previous message: Roji. P. Thomas: "Re: SQL statement with 2 tables"
- Next in thread: Roji. P. Thomas: "Re: Create SQL statements based on table fields values"
- Reply: Roji. P. Thomas: "Re: Create SQL statements based on table fields values"
- Reply: Joe Celko: "Re: Create SQL statements based on table fields values"
- Reply: Anith Sen: "Re: Create SQL statements based on table fields values"
- Messages sorted by: [ date ] [ thread ]