Add Query Layer - Pivot Table from Oracle Database

ModernElectric — Mon, 09 Oct 2017 22:11:02 GMT

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

Re: Add Query Layer - Pivot Table from Oracle Database

AlexandraDubovis2 — Fri, 11 Jan 2019 19:36:50 GMT

Hi, Did you ever figure out? I am trying to create a query layer from our Oracle database and getting the same error.

Thanks,

Alex

topic Re: Add Query Layer - Pivot Table from Oracle Database in Data Management Questions

Add Query Layer - Pivot Table from Oracle Database

Re: Add Query Layer - Pivot Table from Oracle Database