Function addLimitFor11g

backend/plugin/db/oracle/query.go:194–199

addLimitFor11g adds a ROWNUM-based limit for Oracle 11g and earlier versions. Uses the legacy approach with subquery and ROWNUM.

(statement string, limitCount int)

// addLimitFor11g adds a ROWNUM-based limit for Oracle 11g and earlier versions.
// Uses the legacy approach with subquery and ROWNUM.
func addLimitFor11g(statement string, limitCount int) string {
	if !isSelectOrWithStatement(statement) {
		return statement
	}
	return fmt.Sprintf("SELECT * FROM (%s) WHERE ROWNUM <= %d", util.TrimStatement(statement), limitCount)
}

// isSelectOrWithStatement checks if the statement is a SELECT or WITH statement
func isSelectOrWithStatement(statement string) bool {