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";
}