Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

Tags:
Oracle
SQL
SQL scripts
I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.


Software/Hardware used:
Toad/Oracle SQL
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Sound like a homework question. Without knowing what fields and database format we would just be guessing. Post your code and any errors you are getting and we can help straighten it out.
    135,305 pointsBadges:
    report
  • carlosdl
    There is no way in this world for us to know how you have to do that, without knowing the structure of your tables and having a general understanding of your data.

    We can most likely help you, but you need to post the exact structure of the tables involved in this problem, and some sample data, along with the exact results you would want to get from that sample data, and an explanation of the logic behind those results.

    If you omit any of those details, we won't be able to help you.
    85,390 pointsBadges:
    report
  • ToddN2000
    What do you mean by deactivate? is there a flag to be set or is the record to be removed form the table. What are the column names involved? What determines an account paid? Like we have mentioned we need to see the code you have tried so we can better understand the variables involved.
    135,305 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: