How can view keep columns from dictionary
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Wed, 15 Jul 2020 18:24:59 -0300
Message-ID: <CAJdDhaNnF+nV-C6CxQVDhWBcxE8Q+HDTKPt_hZ_ZatjLOugXOA_at_mail.gmail.com>
Hello,
Date: Wed, 15 Jul 2020 18:24:59 -0300
Message-ID: <CAJdDhaNnF+nV-C6CxQVDhWBcxE8Q+HDTKPt_hZ_ZatjLOugXOA_at_mail.gmail.com>
Hello,
I have a doubt about this code :
drop table test;
create view vtest
select * from vtest; -- 2 columns
alter table test add col3 number; -- here table has 3 columns
select * from vtest; -- view keeps using 2 columns
Is there a way to retrieve the current columns from table when created view
as select * from table withou change the view ?
create table test
(col1 number,
col2 number);
as
select * from test;
Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 15 2020 - 23:24:59 CEST