Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

batch insert statements

 
Satish Nair
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
i am designing a financial year table .The Structure of the table is as follows:

---------------------MSTarget----------HSDTarget--------ALPGTarget
April
May
June
July
August
September
October
November
December
January
February
March

All fields are unique.Kindly suggest me a code where i can iterate through all the fields and insert the same in database.I thought of using hashmap for every column.(total 3 hashmap).is it wise to use the same?...If So how do i insert the same in database
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
personally i would do it by hand in an sql script, and then run that using a browser.
Or is the become a regular task with the data changing every year?
 
Satish Nair
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Basically, it would be any user who would be entering the details (Target for financial year) , so i guess the data will keep on changing year on.
Can you please provide me with a sample code to get a clear picture....Thanks in advance
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Satish Nair wrote:Basically, it would be any user who would be entering the details (Target for financial year) , so i guess the data will keep on changing year on.
Can you please provide me with a sample code to get a clear picture....Thanks in advance


We help you sort out the problems you are having with the code you have already written, so you learn by your own mistakes.
here is a link that explains it all better not a code mill
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic