Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming studentsurname is required, the following 2 results were found.

  1. Regular Expressions in SQLhttps://joellipman.com/articles/else/database/regular-expressions-in-sql.html

    And my favorite. Note the circumflex as we are still excluding non-alphanumeric rows. SELECT * FROM Students WHERE studentSurname REGEXP '[^a-zA-Z0-9]'; or SELECT * FROM Students WHERE studentSurname RLIKE '[^a-zA-Z0-9]'; -- returns all rows where the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  2. No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    = trim(:p_myinparameter); SELECT NVL(student_details.studentFirstname, 'John') "FORENAMES", NVL(student_details.studentSurname, 'Smith') "SURNAME" FROM student_details WHERE student_details.studentID = v_studentreference; This errors when the student...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
Results 1 - 2 of 2