T-SQL to PL-SQL

From: stunaz <stunaz_at_gmail.com>
Date: Mon, 26 Apr 2010 07:58:05 -0700 (PDT)
Message-ID: <19a7eb77-cada-42e5-8715-f0f965527a35_at_e14g2000yqd.googlegroups.com>



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
  ) Received on Mon Apr 26 2010 - 09:58:05 CDT

Original text of this message