Delete statements
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Delete statements

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width