public function dropView($viewName, $schemaName = null, $ifExists = true)
{
$this->_escapeChar = '';
$view = Text::upper($this->prepareTable($viewName, $schemaName));
$sql = sprintf('DROP VIEW %s', $view);
if ($ifExists) {
$sql = sprintf("BEGIN FOR i IN (SELECT NULL FROM ALL_VIEWS WHERE VIEW_NAME = '%s') " . "LOOP EXECUTE IMMEDIATE '%s'; END LOOP; END", $view, $sql);
}
$this->_escapeChar = "'";
return $sql;
}