Re: creating table without columns

Hello Everyone,

           I have run below query it is created 'test' table without columns 

           but table row count is 2. 

please give me clarity about this, i thought it may give syntax error but not

either it must have 2 rows data but both are not happened.

with ins_test as (select 1 as srno

union

select 2)

select into test from ins_test;

select * from test;