Oracle Database Discussions

Hi Guys,

I have to create a table which should come from the another table but with an additional column like

we have to create arch_code which is based on the code table which contains the code_id,code_name,code_text but target table should contain arch_date,code_id,code_name,code_text.


Please advise how to achieve this by on the fly method

like create table arch_code AS SELECT ARCH_DATE,* FROM code;

Any suggestions are highly appreciated.


Thanks,
Prafull