Re: select into equivalent of SQL Server

krishna wrote:
>
 

>
> "select * into emp_bak from emp "
>
> where the emp is the table with some records and emp_bak is the table
> created by select into command and it also inserts the records from emp
> table.
>

create table emp_bak as
select * from emp;

HTH, MF

-- 
matt_foster_uk_at_yahoo.co.uk