RE: View Problem
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <SrinivasT@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Oct 2004 11:22:29 +0200
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
