aspose file tools*
The moose likes Oracle/OAS and the fly likes insert multiple values into a single column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "insert multiple values into a single column" Watch "insert multiple values into a single column" New topic
Author

insert multiple values into a single column

Romeo Ranjan
Ranch Hand

Joined: Feb 23, 2009
Posts: 95
Hi all,

I want to insert eight values(rows) into a single column of my table.How do i do that??

This INSERT statement allows to insert a single record or multiple records into a table.


but what i want is


How do i go about doing this??
Trying this format


or


gives me the following error.



SCJP 6.0
Sona Patel
Ranch Hand

Joined: Mar 30, 2009
Posts: 75
Hi Ranjan,

You will have to write different insert statements for all column values as below..

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: insert multiple values into a single column