RE: View Problem

["Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Srinivas T
Sent: Friday, October 01, 2004 10:12
To: oracle-l@xxxxxxxxxxxxx
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

• References:
  • View Problem
    • From: Srinivas T

Other related posts:

View Problem

RE: View Problem

RE: View Problem

RE: View Problem