Home » SQL & PL/SQL » SQL & PL/SQL » INSERT MULTIPLE DATA USING A SINGLE STATEMENT
INSERT MULTIPLE DATA USING A SINGLE STATEMENT [message #19953] Fri, 19 April 2002 23:08 Go to next message
Suparna Saha
Messages: 10
Registered: October 2001
Junior Member
Hi,
I want to insert multiple data without using CURSOR or any loop. In insert statement can I use array as a value? Please suggest any solution. Thanks.

Suparna

Report message to a moderator

Re: INSERT MULTIPLE DATA USING A SINGLE STATEMENT [message #19959 is a reply to message #19953] Sun, 21 April 2002 21:54 Go to previous message
Yuvraj Thapa
Messages: 28
Registered: May 2001
Junior Member
HI ,
you can use
insert into <
> select ........
statement to insert multiple values in single statement.
Regards,
Yuvraj
Kathmandu

Report message to a moderator

Previous Topic: procedures connecting to non Oracle databases
Next Topic: How to tune SQL query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 02:08:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.