Mr Tamil,
I didn't read too much of these posts, I saw your words after I posted mine, and I agree with you. But still wonder why guys here have talked soooo much about this simple problem? Or is there anything else wrong?
Printable View
Mr Tamil,
I didn't read too much of these posts, I saw your words after I posted mine, and I agree with you. But still wonder why guys here have talked soooo much about this simple problem? Or is there anything else wrong?
its bad coding - simple as that
You have to treat date with date datatype only. You should not compromise on that.Quote:
Originally Posted by tamade
I have seen and still am seeing that developers did not treat date as date datatype in Oracle. This posed severe performance problem. If you write date as varchar2 column in a procedure in Oracle 8i, the procedure hangs under certain circumstances.
Tamil