Category Archives: Oracle

Points for Oracle Server

Maximo Hierarchies Report

Posted on 2014-01-22 by QASuper

I went through several options on making Location Hierarchy Reports, and found these queries to be quite beneficial. The code is different, depending on the backend being Oracle or Microsoft. Oracle select level, lpad (‘ ‘, 8 * (level – … Continue reading →

Posted in Maximo, Maximo-5, Maximo-6, Maximo-7, Oracle, SQL, SQL Server (M$) | Comments Off on Maximo Hierarchies Report