Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

insert multiple values into a single column  RSS feed

 
Romeo Ranjan
Ranch Hand
Posts: 95
  • 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
  • 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
Boost this thread!