Phalcon\Db\Dialect\Oracle::listViews PHP 메소드

listViews() 공개 메소드

Generates the SQL to list all views of a schema or user.
public listViews ( string $schemaName = null ) : string
$schemaName string
리턴 string
    public function listViews($schemaName = null)
    {
        $baseSql = 'SELECT VIEW_NAME FROM ALL_VIEWS';
        if (!empty($schemaName)) {
            $schemaName = $this->escapeSchema($schemaName);
            $baseSql .= sprintf(" WHERE OWNER = %s", Text::upper($schemaName));
        }
        return $baseSql . ' ORDER BY VIEW_NAME';
    }