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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why "an INTO clause is expected in this SELECT statement"

Dee102Jan 20 2021

Hello,
I have been a SQL Server developer for couple decades and recently started working on Oracle PL SQL. I have a simple query with a simple question. Maybe you can explain to me why I got that error, so I will understand the concept.Thanks.
declare p_start_dt date := '01-Jun-20';
p_end_dt date := '30-Jun-20';
BEGIN
SELECT *
FROM Table
WHERE date1 <= p_start_dt
and date2 >= p_end_dt;
END;

This post has been answered by mathguy on Jan 20 2021
Jump to Answer

Comments

Post Details

Added on Jan 20 2021
11 comments
26,914 views