sql to output multiple data in single row

SQL Fiddle

Oracle 11g R2 Schema Setup:

CREATE TABLE TEST ( app_name,  batch_group,  session_total ) AS
          SELECT 'app1', 'b1',  5 FROM DUAL
UNION ALL SELECT 'app2', 'b1', 10 FROM DUAL
UNION ALL SELECT 'app1', 'b2', 80 FROM DUAL
UNION ALL SELECT 'app2', 'b2', 99 FROM DUAL
UNION ALL SELECT 'app1', 'b3', 20 FROM DUAL
UNION ALL SELECT 'app2', 'b3', 59 FROM DUAL;

Query 1:

SELECT app_name,
       SUM( CASE batch_group WHEN 'b1' THEN session_total END ) AS session1,
       SUM( CASE batch_group WHEN 'b2' THEN session_total END ) AS session2,
       SUM( CASE batch_group WHEN 'b3' THEN session_total END ) AS session3
FROM   TEST
GROUP BY app_name

Results:

| APP_NAME | SESSION1 | SESSION2 | SESSION3 |
|----------|----------|----------|----------|
|     app1 |        5 |       80 |       20 |
|     app2 |       10 |       99 |       59 |

Query 2:

SELECT * FROM
(
  SELECT *
  FROM   TEST
)
PIVOT 
(
  SUM( session_total)
  FOR batch_group
  IN (
    'b1' AS session1,
    'b2' AS session2,
    'b3' AS session3
  )
)

Results:

| APP_NAME | SESSION1 | SESSION2 | SESSION3 |
|----------|----------|----------|----------|
|     app1 |        5 |       80 |       20 |
|     app2 |       10 |       99 |       59 |