neelesh kumar wrote:i am already so far ahead with it, and i will need to make a lot of changes to all the modules, if i am to change the structure of the table...
Yeah, that's unfortunate. But it is also a sign that you perhaps haven't designed your application in the best possible way. I'd suggest taking this as a possibility to learn how to structure your application better.
You could avoid reingeneering your application by creating the query dynamically, such as
This assumes that you somehow know the number of columns you currently have in the table.
I'd still suggest doing it the right way, though. Adding columns to the table dynamically is really horrible. It would help if you could at least place some limit on the number of days (say, 30), and create columns for all such days. This would allow you to create a static query like
Actually i am developing a windows phone application wherein i require this database..
You're posting in the Oracle forum. Are you really using the Oracle database?