Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling functions with and without parentheses

Jibba JabbaJun 10 2013 — edited Jun 10 2013

Hi,

I'm just wondering, why it is that I can create a function and call it with or without parentheses (e.g. "select f from dual" OR "select f() from dual") but I can only call SYSDATE, CURRENT_DATE etc. without parentheses.  If I do this "select SYSDATE() from dual" I get an error.

SYSDATE is a function, no? 

Does anybody know?  I'm just..curious.

Thanks,

Jason
This post has been answered by Solomon Yakobson on Jun 10 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2013
Added on Jun 10 2013
13 comments
2,628 views