SQL Toad/Oracle strange behavior

Question

I have just installed Toad for Oracle and it has a strange behavior.

This works

select 
*
from 
dd_contract

And this does not, generates errors

select 
*

from 
dd_contract

It is either a FROM not found, or a Invalid statement error. The only difference is that there is and empty line between the last column and the FROM keyword. It is probably some setting somewhere, but I do not even know how to search for it.

Answer 1

Uncheck the "Treat blank line as statement terminator" option on the Execute/Compile page in Options.

You can use Ctrl+Enter to execute code in Toad, that logic uses blank lines as statement terminators.