-
Delete statements
Hi,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|