Skip to Main Content

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!

PLS-00428: an INTO clause is expected in this SELECT statement

Vorlon1Oct 2 2014 — edited Oct 3 2014

Can someone point me to the PL/SQL documentation explaining why this is gets the above error:

DECLARE

X NUMBER := 10;

BEGIN

SELECT TO_CHAR(SYSDATE + X / (24*60*60),'HH:MI:SS') NOW_PLUS_10 FROM DUAL;

END;

/

TIA!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2014
Added on Oct 2 2014
16 comments
5,227 views