I am facing problem with a select query in oracle 10g database from vb.net.It was working for oracle 9.Can anyone help me in finding what the problem is?The select statememnt I have written is as follows
it might be helpful if you actually told us what the problem was. At the moment, your question kind of equates to:
"I have a car, it used to go without any problems, now it it has problems. It is a Ford Cortina 1.8 GL. Can you tell me why it is having problems?"
Also, it is extremely important to use bind variables when selecting from the database. This would improve the performance and would make it more secure.
I see far too many front end developers using string concatenation for running sql queries on the database. This is incredibly bad programming practice. Get out of the habbit!
Suggested reading: http://www.google.co.za/search?hl=en...ariables&meta=