model clause
Hi, Everyone. I have a table as follows
create table drive_time (
drive_date date not null,
empl_code varchar2(40) not null,
clock_time_min number,
break_time_min number,
productive_time_min number,
loads number
)
Is there any way to use model clause to produce a report in such a format ready to load into spreadsheet
May June July
avg_clock_time_min 63333 33354 33652
avg_break_time_min 6520 5239 6985
avg_productive_time_min 56522 32658 32564
avg_loads number 352 258 268
Regards
Sha
create table drive_time (
drive_date date not null,
empl_code varchar2(40) not null,
clock_time_min number,
break_time_min number,
productive_time_min number,
loads number
)
Is there any way to use model clause to produce a report in such a format ready to load into spreadsheet
May June July
avg_clock_time_min 63333 33354 33652
avg_break_time_min 6520 5239 6985
avg_productive_time_min 56522 32658 32564
avg_loads number 352 258 268
Regards
Sha
0