SQL Language (MOSC)

MOSC Banner

Need to have data on one line...

edited Oct 24, 2013 8:00PM in SQL Language (MOSC) 3 commentsAnswered
 Hi I need to have data below appear on columns across the page. I'm not counting, or summarizing anything so I'm not sure if the pivot command can help me.  Another requires is a  "persons" the tasks can change so my column number will change as well.  Can someone help me?
Person      Task                                      Rating 
106011 Analysis/Problem Solving 2
106011 Communication D
106011 Ethics and Integrity
106011 Workload Management D
106011 Action Orientation               3
106011 Coaching
106011 Judgment


Query below... 
SELECT pp.participation_in_id,
  pct.name,
  prl.step_value
FROM per_competence_elements pce ,
  per_all_people_f pap ,
  per_competences_tl pct ,
  per_participants pp ,
  per_rating_levels prl ,

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