All Forums Database
20 Oct 2009
ORacle to Teradata update query conversion

can anybody help with oracle to teradata conversion . update table_a A set display_format = nvl((select prop.propvalue from table_a B, table_c C where B.request_ID = A.request_ID and B.report_Name = A.report_name and B.report_type = A.report_type and C.systemname = 'system' and C.propname = B.report_name || '.' || B.report_type || '.OutputFmt' and C.PROPVALUE in ('yes','No') ), display_format) where request_id = 123 Regards

CarlosAL 512 posts Joined 04/08
22 Oct 2009

Look for UPDATE...FROM sintaxis in Teradata.Cheers.Carlos.

ztpruit 4 posts Joined 10/08
22 Oct 2009

NVL is Oracle's version of the ANSI standard COALESCE function

You must sign in to leave a comment.