Auto Select in SQL Window

[Eickscher]

In former versions (before 7.X) the following worked:
select * from lmdd ; for update;

Now (v7.0.1.1066) I get the "ORA-00911: Invalid character" error.

It would be good to get the old behaviour...

 

[Natalie Arkhipova]

Removing ';' is a problem?
Like this:
select * from lmdd for update;

 

[CTzen]

@Eickscher:

... some unrelated jibber-jabber removed ...

To get rid of the error you can add line comment

select * from lmdd ;-- for update;

 

[Eickscher]

The problem is, that sometimes I want to shorten the select I wrote before. And this was possible only inserting a ';' at the place in the statement to where it should be executed. Now I have to insert additional '--' as a comment or 'ENTER' to move the rest of the line to the next line.

 

[CTzen]

Yes, but it's small inconvenience in my humble opinion

 

[ScottMattes]

I, too, like to shorten my SQLs, but I use the comment method.

I, too, relie on the ';' to say where the end of a SQL is.

I, too, would like the ';' to work, even though I wouldn't use it as described ';' should mark the end of a SQL.

 

[Eickscher]

Hi CTzen,

if it not had worked in the past, I wouldn't miss it...

Ingolf Eick

 

[bcoulam]

I would say that it worked by accident before, and works as it should now. It's one extra keystroke to double-dash it.