SELECT into a table

Hi
I understand that MS Access supports

	Select 
		Col 1, Col 2, Col 3 
	into
		Table2
	From 
		Table1.

May i know is there an equivalent in Oracle besides :

	Insert into  Table2 (Col1, Col2, Col3)
	Select 
		Col 1, Col 2, Col 3 
	From 
		Table1.

Just wondering which is more efficient.

Thanks
Boon Yiang
chuaby_at_hotmail.com Received on Mon Sep 28 1998 - 19:26:07 CDT