Can I create a View based on conditions?
From: Mahesh <maheshvd_at_rediffmail.com>
Date: 28 Jan 2003 03:38:21 -0800
Message-ID: <3b36ea6e.0301280338.30a3df08_at_posting.google.com>
FROM table1 a, table2 b, table3 c, table4 d, table5 e WHERE a.CODE1 = b.CODE1(+)
Date: 28 Jan 2003 03:38:21 -0800
Message-ID: <3b36ea6e.0301280338.30a3df08_at_posting.google.com>
Can I do something like this?
CREATE OR REPLACE VIEW MYVIEW AS
SELECT a.Year Year, DECODE(a.CODE1= d.CODE1,TRUE,d.time,a.HINMOKU_CODE) x, DECODE(a.CODE1= d.CODE1,TRUE,d.time,a.HINMOKU_CODE) y (a.pp/ d.qq * d.rr) g1
FROM table1 a, table2 b, table3 c, table4 d, table5 e WHERE a.CODE1 = b.CODE1(+)
AND a.CODEE2 = e.CODE2;
Is there any alternative?
Thanks in advance. Received on Tue Jan 28 2003 - 12:38:21 CET