File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

insert multiple values into a single column

 
Romeo Ranjan
Ranch Hand
Posts: 95
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.


 
Sona Patel
Ranch Hand
Posts: 75
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranjan,

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

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic