RE: How can view keep columns from dictionary
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-lReceived on Thu Jul 16 2020 - 00:28:34 CEST