RE: View Problem

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 1 Oct 2004 11:22:29 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNIEHNCJAA.lex.de.haan@naturaljoin.nl>

Hi Srinivas,

the "*" in your create view statement is expanded into a list of column names --
check out the USER_VIEWS data dictionary view. this way the view stays valid,
as long as you don't drop the column :-) but you will have to re-create the view
to have the added column show up...

Kind regards,
Lex.

visit http://www.naturaljoin.nl <http://www.naturaljoin.nl>

skype me <callto://lexdehaan>

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Srinivas T Sent: Friday, October 01, 2004 10:12
To: oracle-l_at_freelists.org
Subject: View Problem

HI,
I have created a view .. on the table x;

select * from x

SNO

    1
    2
    3
    4
    5
    6
    7
    8
create view xview as select * from x;

Added a column to the table x

alter table x add (sal number);

select * from x;

SNO SAL
----- ----------

    1
    2
    3
    4
    5
    6

    7       1000
    8       2000

Select * from xview..

SNO

    1
    2
    3
    4
    5
    6
    7
    8

How should I get reflected this in myview......

Thanks in advance..... Srinivas.....

Regards,
Srinivas

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 04:18:13 CDT