Re: creating table without columns

[Greg Spiegelberg <gspiegelberg@xxxxxxxxx>]

On Tue, Oct 30, 2018, 6:45 AM Subodh Kumar <subodh.kumar@xxxxxxxxxxxx> wrote:

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;

See VALUES. 

:)

-Greg