i have one database table with person information (id, fname, lname, street, city…)
i want to search with multiple strings in all columns.
f.e. my searchstring “mainstreet John Doe”
now i want to create a select query (Oracle SQL), which search all strings in all columns.
| fname | lname | street | city | return from select |
|---|---|---|---|---|
| John | Doe | mainstreet | New York | yes |
| John | Doe | street | New York | no |
| Doe | John | mainstreet | New York | yes |
| mainstreet | John | doe | New York | yes |
Is there a way in Oracle SQl to create such a query?
1