Prev: Whitepaper - In-Memory Analytics
Next: T-SQL to PL-SQL
From: stunaz on 26 Apr 2010 10:48 Hello everyone, how could i translate this code to pl-sql. update DM_RE_JOB_POSTING set publishedI = ( select CASE WHEN rjp.internal_external in ('B','I') and COALESCE(rjpd.start_date,'17530101' ) <= CURRENT_TIMESTAMP and COALESCE(rjpd.end_date ,'99991231 23:59:59.997') >= CURRENT_TIMESTAMP THEN 'I' ELSE 'N' END from re_job_posting rjp join re_job_posting_details rjpd on rjpd.re_job_posting_id = rjp.id where rjp.id = DM_RE_JOB_POSTING.ref_re_job_posting_id and rjpd.internal = 1 ), publishedE = ( select CASE WHEN rjp.internal_external in ('B','E') and COALESCE(rjpd.start_date,'17530101' groups.google.caTAMP and COALESCE(rjpd.end_date ,'99991231 23:59:59.997') >= CURRENT_TIMESTAMP THEN 'E' ELSE 'N' END from re_job_posting rjp join re_job_posting_details rjpd on rjpd.re_job_posting_id = rjp.id where rjp.id = DM_RE_JOB_POSTING.ref_re_job_posting_id and rjpd.internal = 0 )
|
Pages: 1 Prev: Whitepaper - In-Memory Analytics Next: T-SQL to PL-SQL |