ORacle to Teradata update query conversion

Database
Enthusiast

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
2 REPLIES
Junior Supporter

Re: ORacle to Teradata update query conversion

Look for UPDATE...FROM sintaxis in Teradata.

Cheers.

Carlos.

Re: ORacle to Teradata update query conversion

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