public function listTables($schemaName = null)
{
$baseQuery = "SELECT TABLE_NAME, OWNER FROM ALL_TABLES %s ORDER BY OWNER, TABLE_NAME";
if (!empty($schemaName)) {
$schemaName = $this->escapeSchema($schemaName);
return sprintf($baseQuery . 'WHERE OWNER = %s', Text::upper($schemaName));
}
return sprintf($baseQuery, '');
}