AnsweredAssumed Answered

Add Query Layer - Pivot Table from Oracle Database

Question asked by ModernGIS on Oct 9, 2017

I am working on importing a bunch of data from our Oracle Database into a File Geodatabase. The way it is set-up in the Oracle database is not how I need it in GIS. I understand I can take the data and manipulate it like you can in Microsoft Excel - by creating a Pivot table and that is exactly what I am trying to do with building a SQL query in ArcMap. 

Right now, I have this SQL Query:

 

select *
from
(
select ACCOUNTNO, VALUE, PHONE_TYPE
from ATSCBS.PHONE_NUMBERS
) src
pivot
(
MAX(VALUE)
for PHONE_TYPE in ('Home' as HOME_PHONE, 'Cellular' as MOBILE_PHONE, 'Business' as BUSINESS_PHONE, 'Pager' as PAGER, 'E-Mail' as EMAIL, 'Fax' as FAX_NUMBER)
) piv
order by ACCOUNTNO

 

It validates just fine however, when I open the table I get this error.

 

Any advice would be great.

Thank You

Outcomes