Re: Create table temp or select into temp.
>> What are the differences between creating a temp table via CREATE TABLE,
>> and selecting INTO TEMP?
the flexibility may be unforeseen.
create table x (
y smallint
a int,
b char(20)
);
<populate table>
<Problem: want narrow column output>
select y, a, b
from x;
<or>
create temp table t (
y dec(2,0),
z char(10)
);
insert into t
select y, a||" "||b
from x;
select * from t;