You must run this product with JavaScript enabled.
Welcome nobody
(
Logout
)
Home
Home
Learn Application Express
Demonstrations
Pivot
Help
About
This report demonstrates the PIVOT SQL syntax introduced in Oracle 11g.
Demos
Calendar
Chart
Data Entry Form
Hierarchy
Interactive Report
Map
Master Detail
Pivot
Dashboard
Tree
XML
Reset
Select columns to search
Go
Actions
Select Columns
Filter
Rows Per Page
1
5
10
15
20
25
50
100
1000
All
Format
Sort
Control Break
Highlight
Compute
Aggregate
Chart
Group By
Flashback
Reset
Help
Download
Country
President
Manager
Analyst
Salesman
Clerk
Total
Australia
0
1
4
0
1
6
Austria
0
0
2
1
1
4
Brazil
0
1
4
0
0
5
Canada
0
1
0
0
5
6
China
0
1
5
1
0
7
Egypt
0
1
2
0
1
4
France
0
1
3
0
2
6
Germany
0
1
7
1
2
11
India
0
1
3
2
0
6
Ireland
0
1
4
1
0
6
Japan
0
1
4
0
1
6
Kenya
0
1
2
0
1
4
Russia
0
1
4
0
1
6
South Africa
0
1
2
0
1
4
Spain
0
2
2
2
0
6
United Kingdom
0
0
2
0
0
2
United States
1
3
2
4
4
14
1 - 17
SQL
ORA-01089: immediate shutdown in progress - no operations are permitted