select into equivalent of SQL Server

From: krishna <krishna_lakshman_at_sg.exch.agilent.com>
Date: Fri, 22 Dec 2000 14:43:44 +0800
Message-ID: <977467408.916117_at_cswreg.cos.agilent.com>


Hi there,

Iam new to oracle. I quite familier with SYBASE. I need to know how I can do the following of SYBASE in ORACLE.

[Quoted] "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.

Please do help me on this to do the same thing in oracle. I find select into does not work in oracle.

Thanks in advance
Krishna. Received on Fri Dec 22 2000 - 07:43:44 CET

Original text of this message