Identify the SQL wildcard character in Oracle which represents zero, one, or…
2018
Identify the SQL wildcard character in Oracle which represents zero, one, or multiple characters? Options:
- A.
Percent (%)
- B.
Underscore (_)
- C.
Question mark (?)
- D.
Asterisk (*)
Attempted by 317 students.
Show answer & explanation
Correct answer: A
In Oracle SQL, the percent sign (%) acts as a wildcard for zero, one, or multiple characters. The underscore (_) matches exactly one character instead.