Doctrine\DBAL\Platforms\OraclePlatform::getListTableIndexesSQL PHP Method

    public function getListTableIndexesSQL($table, $currentDatabase = null)
    {
        $table = $this->normalizeIdentifier($table);
        $table = $this->quoteStringLiteral($table->getName());
        return "SELECT uind_col.index_name AS name,\n                       (\n                           SELECT uind.index_type\n                           FROM   user_indexes uind\n                           WHERE  uind.index_name = uind_col.index_name\n                       ) AS type,\n                       decode(\n                           (\n                               SELECT uind.uniqueness\n                               FROM   user_indexes uind\n                               WHERE  uind.index_name = uind_col.index_name\n                           ),\n                           'NONUNIQUE',\n                           0,\n                           'UNIQUE',\n                           1\n                       ) AS is_unique,\n                       uind_col.column_name AS column_name,\n                       uind_col.column_position AS column_pos,\n                       (\n                           SELECT ucon.constraint_type\n                           FROM   user_constraints ucon\n                           WHERE  ucon.constraint_name = uind_col.index_name\n                       ) AS is_primary\n             FROM      user_ind_columns uind_col\n             WHERE     uind_col.table_name = " . $table . "\n             ORDER BY  uind_col.column_position ASC";
    }