Multiple choice technology databases

O/p of the below query ?? select 'a''a' from dual;

  1. aa

  2. a a

  3. a'a

  4. Error: invalid identifier

  5. Error: invalid character
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle SQL, a single quote within a string literal is escaped by doubling it. Two consecutive single quotes ('') represent one literal quote character. The string 'a''a' contains characters a, ', a - outputting a'a.

Keep practicing — related questions