Asp.net,SQL tips-Tricks for error resolution version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,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

No comments:

Post a Comment