I have two databases, Development and Production.
Delete satement on Development works but not on the production without quotes.
The table structure and datatypes of both the tables are same on both the database.
Ideally we should give quotes for varchar2.
But on Development it works without quotes for O_NO; but not on production. The datatypes on both the D/B for O_NO column is same ie., VARCHAR2.
DELETE FROM WHERE O_NO=61340 AND P_ID=2 AND MEMBER_ID<>'65804'
I am using 9i 2nd release on unix.
What do you mean by "doesn't work" ... do you get an error? If so, I'd suspect that the O_NO column has a value in production that cannot be implicitly converted to a number.
Click Here to Expand Forum to Full Width