Multiple insert statement or One dynamic insert [message #400602] |
Wed, 29 April 2009 01:36 |
|
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
Hello Gurus,
Have look at following facts
SQL>select * from v$version;
BANNER
================================================================================
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
5 rows selected.
SQL>desc approved_links;
Name Null? Type
----------------------------------------- -------- ----------------------------
APPROVAL_PK NOT NULL NUMBER
MASTER_LINK_FK NUMBER
CHILD_LINK_FK NUMBER
ENGINE_FK NOT NULL NUMBER(3)
RANK NUMBER
CREATED_BY_FK NOT NULL NUMBER
CREATED_ON NOT NULL TIMESTAMP(6)
LAST_LOGIN_FK NOT NULL NUMBER
LAST_MODIFIED NOT NULL TIMESTAMP(6)
LAST_MC NOT NULL VARCHAR2(50)
LAST_IP NOT NULL VARCHAR2(20)
Now I have to insert more than three rows at a time in this table.
What approach if insertion should I follow -
1>multiple insert statement one by one or
2>One dynamic 'insert all' statement
?
Please suggest me the optimized way.
regards,
Delna
|
|
|
|
|
|
|
|
|