Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View Problem

RE: View Problem

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Fri, 1 Oct 2004 10:26:11 +0100
Message-ID: <EA29A3FCC723674293FD6286D3F0513E8F4A05@louis.cerebrus.com>


Re-create the view

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Srinivas T Sent: 01 October 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=20

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:20:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US