我发现如何正确地做，一般的例子：

select 'update table_name set column_name = 
'||variable_from_target_table||' where column_code = 
'||variable_from_target_table_2||';' from target_table;

例如：

select  'update some_table_1 set
  s_name = ''' ||s_name|| ''' where s_code = ''' ||s_code|| ''';' from some_table_2;

这将生成更新：

update some_table_1 set s_name = 'Jon' where s_code = 'Y';
update some_table_1 set s_name = 'Adam' where s_code = 'Y';
update some_table_1 set s_name = 'Matt' where s_code = 'Y';
update some_table_1 set s_name = 'Jess' where s_code = 'Y';
update some_table_1 set s_name = 'Carl' where s_code = 'Y';

我认为当你想生成许多语句时，这很有用。

select 'update some_table_1 t1 set t1.s_name = ''' +  D.CODE + ''' 
where some_table_2.s_code = some_table_1.code; ' from ADMDEPTMAST D;

以上查询我是在SQL2008中执行的