You need to end your queries with a semicolon. That is the delimiter for queries and DDL statements.
Forward slash is the delimiter for PL/SQL blocks.
Line breaks are not delimiters, the following would execute just fine if you do Control+Enter while your cursor is on the word "select".
dual where 1=1;
1 person found this helpful
To me it is not annoying. This way I don't have to care about empty lines and it is possible to have multiple statements in a worksheet and execute a single statement when the cursor is placed within it.
semicolon works. Thanks .
If you're curious why we require actual statement delimiters instead of guessing based on empty lines, consider these possibilities:
/* everything OK so far */
delete from hr.employees
where hire_date is null;