View Problem

  • From: "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Oct 2004 14:41:57 +0530

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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2004