ORA-00933 in SQL Window

[MundeX]

Statement (no errors):

SELECT * FROM DUAL
/

Statement (with error ORA-00933):

SELECT * FROM DUAL
 /

When befor "/" I put space (one or more) get ORA-00933. Can I fix this?

 

[Marco Kalter]

Only slashes at the beginning of a line are interpreted as a command separator. Otherwise the text is sent to the server as is.

 

[MundeX]

I'm able to somehow turn off? To "/" was always the "/"?

 

[Marco Kalter]

I'm not sure I understand, but there are no configuration options to control the exact / interpretation nuances. It has to be the first character on the line.

 

[MundeX]

Originally posted by Marco Kalter:
I'm not sure I understand, but there are no configuration options to control the exact / interpretation nuances. It has to be the first character on the line.

Exactly so mean. I would like to make "/" was always regarded as the end of command regardless of the number of spaces.

 

[yonderboi]

Hello!
Another problem with ORA-00933. Verson 11.0.3
How to reproduce it with HR schema
1) Open an SQL-window(tab 1)
select * from jobs;
2) Using linked query go to employees table. So you have a tab 2 with
select * from EMPLOYEES t
where t.job_id = :m_job_id
3) Write down some text below.
select * from EMPLOYEES t
where t.job_id = :m_job_id

qwery
4) Then return to tab 1, requery
select * from jobs;
It doesn't matter whether you preselect query or just press F8
For some strange reason PLSQLDev query what it has on an inactive tab 2, "select * from EMPLOYEES t where t.job_id = :m_job_id" and "qwery" and you'll see "ORA-00933: SQL command not properly ended"

 

[IvanZ]

The reason is linked query.