SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How could I write a trigger to get the sum of values held in a different form?

User_6OSDLMar 30 2021 — edited Mar 30 2021

DECLARE
     V_FEE NUMBER(5, 2);
BEGIN
     SELECT FEE INTO V_FEE FROM LIST
     WHERE :REGISTRATION.DCODE = MODULE.DCODE;

     :DEBT_FEE:= V_FEE;
END;

I was wondering how I could do something similar to get the sum of all the debts the current debtor owes. Any help would be appreciated.

NickR2600-Oracle

So when would it be beneficial to have an abstract method in a super class? One answer would be because the sub classes have no shared functionality. Or in other words, because the functionality is so different between subclasses. Or because the functionality can't be defined yet.

In Java Puzzle Ball, I have an abstract class called GameObject. It's inherited by a lot of different concrete classes: bumpers, assignable behaviors, level geometry... And one if its responsibilities is to define what happens when a collision occurs. But I have to leave the collision effect method abstract. The geometry of all these objects are so dramatically different, there isn't any shared functionality I can write to define how the physics of all these different angles and shapes should work. The best I can do is write an abstract method as a promise to implement the functionality somewhere later down the inheritance structure.

1 person found this helpful

AjayKumarGuttikonda

Thank you so much for taking time out and answering the question in very elaborated manner. I understand, the conclusion is Account class need not be abstract as all methods are implemented and also there is no problem Account class being abstract as the abstract class by definition can have all methods implemented. Can you please also explain why in this case it is beneficial to have Account class as abstract since we have implemented all methods.

NickR2600-Oracle

You got it. I'm glad you're enjoying the course

It's more of a design choice in this example. Even though Account could technically exist as a concrete class, I only meant for it to be a container for all the fields and methods shared by savings and checking accounts. So to reinforce that decision and prevent instances of Accounts from getting created, the class is left abstract.

One other thing to consider is that Accounts don't have an accountType field, but savings and checking account classes do. Looking back, maybe I should have written an abstract method into the Account class to somehow enforce the need for this field.

1 person found this helpful

1 - 3

Added on Mar 30 2021

#oracle, #pl-sql

6 comments

495 views

2 mentions

SQL & PL/SQL

How could I write a trigger to get the sum of values held in a different form?

Comments

Post Details