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

getListTableColumnsSQL() public method

{@inheritDoc}
public getListTableColumnsSQL ( $table, $database = null )
    public function getListTableColumnsSQL($table, $database = null)
    {
        $table = $this->normalizeIdentifier($table);
        $table = $this->quoteStringLiteral($table->getName());
        $tabColumnsTableName = "user_tab_columns";
        $colCommentsTableName = "user_col_comments";
        $ownerCondition = '';
        if (null !== $database && '/' !== $database) {
            $database = $this->normalizeIdentifier($database);
            $database = $this->quoteStringLiteral($database->getName());
            $tabColumnsTableName = "all_tab_columns";
            $colCommentsTableName = "all_col_comments";
            $ownerCondition = "AND c.owner = " . $database;
        }
        return "SELECT   c.*,\n                         (\n                             SELECT d.comments\n                             FROM   {$colCommentsTableName} d\n                             WHERE  d.TABLE_NAME = c.TABLE_NAME\n                             AND    d.COLUMN_NAME = c.COLUMN_NAME\n                         ) AS comments\n                FROM     {$tabColumnsTableName} c\n                WHERE    c.table_name = " . $table . " {$ownerCondition}\n                ORDER BY c.column_name";
    }
OraclePlatform