RE: How can view keep columns from dictionary

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_at_gmail.com<mailto:ecandrietta_at_gmail.com>> 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

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