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>


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

Original text of this message