拼装SQL.例子

select 'update adempiere.m_product p set p.length=' || p.length ||
' , p.width=' || p.width || ' , p.height=' || p.height || ',
p.weight =' || p.weight || ' where p.length = 0 and p.width = 0 and p.height = 0 and p.weight= 0 and p.sku = ''' ||
p.sku || ''' and p.isnew=''Y'';',
p.*
from adempiere.m_product p
where p.length <> 0
and p.width <> 0
and p.height <> 0
and p.weight <> 0
and p.isnew = 'N';

 

得到的例子:

update adempiere.m_product p set p.length=5 , p.width=9 , p.height=3,
p.weight =.035 where p.length = 0 and p.width = 0 and p.height = 0 and p.weight= 0 and p.sku = 'M010000000000000252' and p.isnew='Y';