inserting new year

Question

hii   i m trying to insert new year in database from asp.net by comparing which was the last year in the database. ex:---i have a column in  database like 01-2016,02-2016,03-2016......12-2016,i have to check that 2016 is last year if i will enter 2017 in textbox  and after button click i need to insert in database like 01-2017,02-2017.... like that automatically. give me some idea how i will do.

Dorababu Meka · Accepted Answer

Attaching the code modify as per your required

Dorababu Meka · Answer

OK please go through the documentation for XMLType http://docs.oracle.com/cd/B10501_01/appdev.920/a96620/xdb04cre.htm

nirjharini pradhan · Answer

No because i m new in .net field  and i m using back end as oracle database.

Dorababu Meka · Answer

What you didn't get in that stored procedure if you parse your data as XML from UI side it will insert the data at one go.

nirjharini pradhan · Answer

Thanks for solving my problem .sorry but i m unable to understand your stored procedure can u please convert that procedure into single query.   Thanks In advance

nirjharini pradhan · Answer

yes code is primary key

nirjharini pradhan · Answer

no

Dorababu Meka · Answer

So code is primary key ? Any auto identity column in your table

nirjharini pradhan · Answer

code                     from-date               to-date 2016-01              01-jan-2016         30-jan-2016 2016-02               01-feb-2016        29-feb-2016 . . .  i want if i enter 2017 in textbox and then button click then like  the above manner  automatic for 12 month the 12 record will be inserted for year 2017.

Dorababu Meka · Answer

Ok can you show me your actual table data how it look like or can you share the script of your table so that I will give a try