Multiple choice technology databases

Output of the below query will be.. select '#' from dual;

  1. Error: invalid identifier

  2. Error : Invalid Character

  3. NULL

  4. #

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When '#' is enclosed in single quotes, Oracle treats it as a string literal, not a comment symbol. The query SELECT '#' FROM dual simply returns the character '#' as a string value. No error occurs because it's properly quoted.