SQL Language (MOSC)

MOSC Banner

model clause

edited Nov 3, 2010 11:04PM in SQL Language (MOSC) 9 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center