From: stunaz on
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' )
<= CURRENT_TIMESTAMP
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
)