8- HOW TO CONVERT EXCELL DATA AS ORACLE TABLE DATA
As you are aware Oracle Application Express swings around Oracle Database and in a way it can be classified under CLASSIC RELATIONAL DATABASE. In any relational database groups of data are stored 1 implemented as tables. Now we shall try to understand this table concept differently. At the start of the session, you said that you are having excel sheets wherein account heads are stored as follows
In excel sheet, Column A is used for Account_Head and
Column B is used for Account Type. Account Head Account Type Capital Account Capital
Cash Account Capital Bank Account Capital Fixed Asset Capital Loan Account Capital Inventory Capital Reserves and Surplus Capital Investment Capital Purchase Revenue