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.
>= CURRENT_TIMESTAMP
from re_job_posting rjp
join re_job_posting_details rjpd on rjpd.re_job_posting_id = rjp.id
>= CURRENT_TIMESTAMP
from re_job_posting rjp
join re_job_posting_details rjpd on rjpd.re_job_posting_id = rjp.id
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 ,'9999123123: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 ,'9999123123: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