RE: How can view keep columns from dictionary

From: Jackie Brock <J.Brock_at_cablelabs.com>
Date: Wed, 15 Jul 2020 22:28:34 +0000
Message-ID: <CY4PR06MB32393FE6A443661B071D8B1DF37E0_at_CY4PR06MB3239.namprd06.prod.outlook.com>



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
Received on Thu Jul 16 2020 - 00:28:34 CEST

Original text of this message