Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with Computed Column

Problem with Computed Column

From: TheanKeong <theankeong_at_gmail.com>
Date: 27 Feb 2005 20:30:58 -0800
Message-ID: <1109565058.254124.119130@g14g2000cwa.googlegroups.com>


Hi,
I am a newbie in Oracle and I am currently facing a problem with migrating my SQL statement to Oracle. The statement looks like this

create or replace view dbo."v_crm_events_detail_analysis" as
(select pd_type from dbo.party_dtl where pd_id=(select ceh_pt_id from
dbo.crm_events_hdr where ceh_id=ced_ceh_id) and pd_type in('C','P')) as Pd_Type,

(case when Pd_type='C' then 'Customer'

          when Pd_Type='P' then 'Prospect' end) as Party_type,

FROM dbo.Party

I got an error indicating INVALID identifier PD_TYPE. The error happens in my Case Section. Is it that Oracle cannot identified COmputed Columns in such circumstance or I am doing things wrongly? Or is there any workaroung ?

Thanks
Kwan Received on Sun Feb 27 2005 - 22:30:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US