|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/18/2009 10:51:12 AM
Posts: 6,
Visits: 36
|
|
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
Regards.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/22/2009 10:24:19 AM
Posts: 39,
Visits: 213
|
|
Look for UPDATE...FROM sintaxis in Teradata.
Cheers.
Carlos.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/22/2009 4:33:00 PM
Posts: 1,
Visits: 18
|
|
|
NVL is Oracle's version of the ANSI standard COALESCE function
|
|
|
|