Multiple choice technology databases

Is Sysdate a system variable or a system function?

  1. System Variable

  2. System Function

  3. Both A & B

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SYSDATE in PL/SQL is a pseudo-column that returns the current date and time from the database server. It is implemented as a function call that gets evaluated each time it is referenced, not a stored variable value. This is why SYSDATE always returns the current time when called.

Keep practicing — related questions