将一个表的数据复制到临时表并在临时表添加字段

随手笔记
create table a(sm varchar2(200));

create table ss_temp as (
select ss.*,a.sm from ss,a where 1=0);

insert into ss_temp (
select ss.* ‘110’ sm from ss where ss.id in(
select c.id from c where c.id=‘1010’));