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

getListTableForeignKeysSQL() public method

{@inheritDoc}
public getListTableForeignKeysSQL ( $table )
    public function getListTableForeignKeysSQL($table)
    {
        $table = $this->normalizeIdentifier($table);
        $table = $this->quoteStringLiteral($table->getName());
        return "SELECT alc.constraint_name,\n          alc.DELETE_RULE,\n          cols.column_name \"local_column\",\n          cols.position,\n          (\n              SELECT r_cols.table_name\n              FROM   user_cons_columns r_cols\n              WHERE  alc.r_constraint_name = r_cols.constraint_name\n              AND    r_cols.position = cols.position\n          ) AS \"references_table\",\n          (\n              SELECT r_cols.column_name\n              FROM   user_cons_columns r_cols\n              WHERE  alc.r_constraint_name = r_cols.constraint_name\n              AND    r_cols.position = cols.position\n          ) AS \"foreign_column\"\n     FROM user_cons_columns cols\n     JOIN user_constraints alc\n       ON alc.constraint_name = cols.constraint_name\n      AND alc.constraint_type = 'R'\n      AND alc.table_name = " . $table . "\n    ORDER BY cols.constraint_name ASC, cols.position ASC";
    }
OraclePlatform