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-201602-201603-2016......12-2016i 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-201702-2017.... like that automatically. give me some idea how i will do.

Dorababu Meka · 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

nirjharini pradhan · Answer

yes all data will be in order manner bcoz this date column is my primary key acoording to my date column only data is ordered

Dorababu Meka · Answer

What else you have in your table and is the data will be in ordered manner as follows or will it be random 01-201502-201503-2015......12-2015 01-201602-201603-2016......12-2016

nirjharini pradhan · Answer

yes My column type varchar

Dorababu Meka · Answer

Is your column type Varchar ?