Skip to Main Content

SQL Developer

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!

SQL Dev 4 EA3: Default append/replace double click behaviour for SQL History

906783Nov 6 2013 — edited Jan 2 2014

My previous default behaviour of appending SQL history when a statement is double clicked has been replaced by a replace.

I have dim and distant memories of setting this default behaviour in a previous version of SQL Developer, but can't find/recall a way of doing it now.

If this is set in the preferences, then my preference has not been carried forward in 4 EA3.

I know I can click the icon to the left of the SQL statement, but that is a more cumbersome <click>, <move mouse>, <click>, rather than the previous <double click> that worked as recently as 4 EA2.

Comments

contemplator

It's funny that the day before, I get stumped by a problem the whole day... then the next day I find the answer to my problem.

The view is actually working. but the last record is not appearing. This is the same for my tables. no last record.

I get 3 rows in the table in the SQL Command Line.

I get 2 rows in the view in the SQL Command Line.

I get 2 rows in the table in the PHP Web page.

I get 1 row in the view in the PHP Web page.

I have only changed the select statement, the rest of the code is the same.

help?

contemplator

OK, I have just figured it out.

Oracle 11g XE allows for one session. Connecting to Oracle through PHP counts as a session.

Disconnecting the console fixed the problem.

Christopher Jones-Oracle

You can have more than one session at a time to XE.  At a guess, you hadn't committed in the first session and disconnecting performed the commit for you.  This let the other session see the data.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 30 2014
Added on Nov 6 2013
2 comments
558 views