3 Replies Latest reply: Dec 7, 2013 3:49 AM by Vijetha RSS

    How to manipulate data in multiple rows without using cursor??

    Vijetha

      Hi all,

      I have a form in which there is a push button & 4 text fields.

      Push button : Process

      Text fields: Year, Month, Financial_To_Year, Financial_From_Date.

      In database , there are tables like, CUSTOMER_MASTER, FD_ACCOUNT_MASTER, FD_ACCOUNT_DTL, CUSTOMER_YEARLY_INTEREST, etc.

      In table FD_ACCOUNT_MASTER, there are columns, like CUST_CODE, FD_ACCT_NO, FD_AMOUNT, ACCT_OPEN_DT, ACCT_CLOSE_DATE, ACCT_TYPE, INTEREST_RATE, etc.

      There are thousands of records in the table.

      For Push button : Process , TRIGGER: When button pressed,

      I have to do all the process of FD for all the FD_ACCOUNTS at once. Process means i have to calculate Interest for all the accounts, calculate interest monthly, quarterly, yearly and make the FD_Accounts disable after the date of ACCT_CLOSE_DATE is reached, make the accounts renewed , etc all the process.

      But to do this process for multiple rows at once, we use cursor, but i don't want to use cursor as i feel its too tedious to do.

      Is there any other way , where i do process of multiple records at once without using cursor??

      Help me, Thank You.

       

      Oracle Forms Builder 6i.

      Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production