i have data in excel, how can create the table structure for month name and month value in rollup function in reporting SQL.
CREATE TABLE "EXPENCES_TABLE"
( "SL" NUMBER,
"EXPENCES_TYPE_LOV" NUMBER,
"EXPENSE_ACCOUNT_NUMBER" NUMBER,
"ACCOUNT_NAME" VARCHAR2(25),
"JAN_MONTH" DATE,
"JAN_AMOUNT" NUMBER
--how can add the month and value in same table? the above column method is correct way?
) ;
