Asp.net,PL/SQL tips-Tricks for error resolution version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Visual Studio,Film,Musical notations,Indian ,Western Music.

January 3, 2013

Bulk insert records into table in sql or oracle

This is the way to Bulk insert records into table in sql or oracle

insert into dTable select * from sTable

if dTable is blank and doesn't have any record.

Create this as follows: definately reduce the time.

CREATE TABLE dtable NOLOGGING AS SELECT * FROM stable