SQL Language (MOSC)

MOSC Banner

requirement to add process and grants data to an existing OTL SQL

edited Jun 26, 2012 8:09AM in SQL Language (MOSC) 3 commentsAnswered
   Hello Guru's

I have a requirement to add process and grants data to an existing OTL query.  The query doesn't return any value, however I know that it should.. Does anyone have an example I can leverage? Here is what I've done so far

SELECT htg.tk_group_name group_name,
    papf.full_name full_name,
         htb.start_time,
     htb.stop_time,
     initcap(TO_CHAR(htb.start_time,'DAY')) DAYY,
    tbb_det.approval_status approval_status,
    element_name Hours_Type,
    SUM(tbb_det.measure) monday_tot_hrs,
    0 tuesday_tot_hrs,
    0 wednesday_tot_hrs,
    0 thursday_tot_hrs,
    0 Friday_tot_hrs,
    0 Saturday_tot_hrs,

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