Skip to Main Content

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 to create table structure for roll up month name and month data

ar_dev_meaOct 13 2018 — edited Oct 14 2018

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?

) ;

table stucture.png

This post has been answered by mNem on Oct 13 2018
Jump to Answer
Comments
Post Details
Added on Oct 13 2018
10 comments
1,179 views