Re-run the script. 😊
Best regards,
Jackie Brock| Database Engineer
CableLabs® | p 303.661.9100
Stay up to date with CableLabs: Read the
blog<http://www.cablelabs.com/news-events/blog/> and follow us on
Twitter<https://twitter.com/CableLabs>.
On Wed, 15 Jul 2020, 22:26 Eriovaldo Andrietta,
<ecandrietta@xxxxxxxxx<mailto:ecandrietta@xxxxxxxxx>> wrote:
Hello,
I have a doubt about this code :
drop table test;
create table test
(col1 number,
col2 number);
create view vtest
as
select * from test;
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 ?
Regards
Eriovaldo