RE: How can view keep columns from dictionary

From: Jackie Brock <>
Date: Wed, 15 Jul 2020 22:28:34 +0000
Message-ID: <>

Re-run the script. šŸ˜Š

Best regards,

Jackie Brock| Database Engineer
CableLabsĀ® | p 303.661.9100

Stay up to date with CableLabs: Read the blog<> and follow us on Twitter<>. On Wed, 15 Jul 2020, 22:26 Eriovaldo Andrietta, <<>> wrote: Hello,

I have a doubt about this code :

drop table test;
create table test
(col1 number,
 col2 number);

create view vtest
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 ?


Received on Thu Jul 16 2020 - 00:28:34 CEST

Original text of this message