5 Replies Latest reply: Jan 7, 2014 10:05 AM by Andreas Weiden RSS

    How to insert value from FORM to a different table in database??

    Vijetha

      Hi All,

      I have the following problem.

       

      I have a form which has tabular layout for the table MATURED_FD_DTL. (around 20 line items)

       

      CREATE TABLE MATURED_FD_DTL

      (

        ACCT_FD_NO    VARCHAR2(17 BYTE)               NOT NULL,

        CUST_CODE     NUMBER(9),

        FD_AMT        NUMBER(15),

        FD_INT_BAL    NUMBER(15),

        TDS           NUMBER(15),

        CHQ_NO        NUMBER(10),

        CREATED_DATE  DATE,

        CREATED_BY    VARCHAR2(15 BYTE),

        PREV_YR_TDS   NUMBER(15),

        ADD_FD_AMT    NUMBER(15),

        DESCRIPTION   VARCHAR2(100 BYTE),

        P_SAP_CODE    NUMBER(10),

        P_TYPE        VARCHAR2(1 BYTE)

      )

       

      By clicking 'SAVE' button , all the values will automatically gets saved in the database table MATURED_FD_DTL.

      But i want to insert these values into another table called TEMP.

      I want the values to be inserted from form only, not select from table.

      How do i do this??

       

      Help me.

      Oracle Forms Builder 6i.