|Very useful future I'm waiting for it!||10||05-JUL-19|
|SQLDeveloper Team: I think it's time to implement this.
Yes, make the developer actually type the 'FOR UPDATE' clause. Yes, make the developer actually click an icon to 'unlock' the records.
OR (if this makes it more palatable for the development team [see the previous post where Jeff didn't think this was a good thing to do as above])
Give me the ability to pass a where clause from a query in a worksheet to the data grid for a table.
Filtering rows on a data grid is possible (it's just a bit tedious in my opinion), let me quickly pass the where clause in.
Allow us to type in a where clause on the data grid!
Any of the above would work.||10||07-FEB-19|
|Don't what's against building this: select * from emp where ename like 'A%' for update; => data updatable so change grid to edit mode...||10||17-APR-18|
|This would be very helpful||10||10-APR-18|
|Not sure what else to do other than vote on this already rejected request.
At the end of the day, we're not going to switch databases because of this (specifically). It's the little things like this that add up though. At one time IBM owned the O/S market. They didn't listen to what users wanted though, and so Microsoft came along and listened...and dominated. ...then Microsoft became too big to care or listen, and now we (like most companies) are moving servers to Linux.
Oracle still has a commanding share of the market (although slipping). Give it a few more years of ignoring the priorities of its users, and let's see where things stand. Once the downward slide starts it's very difficult to regain the former glory.||10||14-MAR-18|
|While it's not a feature I use myself (I prefer the old fashioned way), it's the number 1 feature request that keeps coming back from more casual Oracle users and developers. As long as this feature is not present, it's very hard to convince them to drop their old IDE and to migrate to SQL Developer.||10||24-JAN-18|
|Would be useful.||10||13-OCT-17|
|Our employees always asking me about this feature||10||14-JUL-17|
|Very useful feature.||10||25-JUN-17|
|This is very important feature for a developers||9||09-MAY-17|
select ... for update||10||01-MAR-17|
|It would be very convenient for me to edit value in query result. Wish this feature could be implemented ASAP. ||10||17-NOV-16|
|Please reconsider this feature! <3||10||25-OCT-16|
|one of the important feature in PLSQL Developer. I hope you should consider it before I can move to SQL Developer||10||14-JUN-16|
|Please we need this functionality.... thanks for that||10||04-MAY-16|
|Oracle only listens to the sound of money. ||10||30-JUN-15|
|I really like Jeff Smith, but he treated me rather curtly when I emailed last year in disbelief that SQLDev did not yet have this feature. His reply essentially indicated they thought it was a bad idea, that all customers were wrong and they'd never implement it. I'm astounded Oracle refuses to listen to common sense and customers about this feature request. It is essential. Note that many of your customers refuse to move to SQL Dev until this feature is implemented. It is expected of ANY database development tool, let alone the leader and pioneer in database technology.||10||11-JUN-15|
|Oracle lacks behind (again)||10||21-APR-15|
|Why was this rejected? Other products have this feature and it's extremely beneficial.||10||30-MAR-15|
|This would be great (it's the main reason that I still use TOAD).
Why was this rejected?||10||13-MAR-15|
|I agree. This is a neat feature. Rather than writing an entire update statement, I can just:
1. lock the record(s),
2. change the data,
3. post the changes, and
You may restrict this feature to results sets generated out of a single table only.
We're currently able to do this in PL/SQL Developer (from Allroundautomations)||8||11-MAR-15|
|A great tool needs that feature. Please reconsider.||10||10-MAR-15|
|#1 reason given from team unwilling to move from SqlNav to this tool.||10||22-OCT-14|
|I use Toad or PLSQL Developer to use this feature. You use select * from <<table_name>> for update ; Result set becomes editable once you click on lock icon. This is the single most feature requested on this forum.
Sad to see status as Rejected. Any software/tool should increase productivity instead of forcing one/another way of doing something.
Just hope it will be reopened and will be a feature in future version.||10||24-SEP-14|
|This would be great to have such feature in SQL Developer. In TOAD there is such handy feature and it was implemented years ago.||10||29-AUG-14|
|This option i used in TOAD is very helpful and i want to please to put it in the SQL Developer, the classic and accurate tool to administer database objects and do the standard work with Oracle database. Many thanks. ||10||01-AUG-14|
|I NEED IT LIKE TOAD ^^||10||27-MAY-14|
|it will save my time if i was able to edit the result directly..||10||20-MAY-14|
|Ciertamente, una caracteriztica muy necesaria para una rapida actualizacion de datos filtrados, sobre todo cuando se usan diferentes tablas.||10||15-MAY-14|
set a = :x
where id = :par
Yes, i know what did i updated, ty but no!||1||24-APR-14|
|need this feature||10||23-APR-14|
|The only one feature missing||10||22-APR-14|
|Top from balada||10||04-APR-14|
|i think so it is more important defect||10||19-MAR-14|
|Useful for quick data changes. Also would help me to switch from PL/SQL Developer.||10||14-MAR-14|
|Don't think SQL developer is the right tool for this task. there are fare more important features that developers of SQL developer should focus on||1||07-MAR-14|
|I think it's bad idea. You are not in Excel spreadshit.||1||06-MAR-14|
|Needed to replace Toad and PL/SQL Developer||10||13-FEB-14|
|Lack of this feature keeps our development team still with SQL Navigator. We are waiting for you...||10||03-FEB-14|
|It would be a very useful feature.||10||31-JAN-14|
|Would be so helpful, I used it a lot in Toad.||10||30-JAN-14|
|So very useful for quick data changes. ||10||16-JAN-14|
|this is minimum requirement for the entry level users||10||17-DEC-13|
|This is a basic feature which should be available in SQL Developer.||10||16-DEC-13|
|This is so common feature in all other products. I highly use this feature most of times. Sadly I don't like going to data tab just to update one cell value. It's not efficient. Please put this feature in new version. it will give many developers to use sql developer as their primary tool.||10||21-NOV-13|
|make it lockable by adding something into the sqldeveloper.conf (protection against newbies)||8||14-NOV-13|
|Currently I go to Toad to edit some lookups. This is necessary.||10||07-OCT-13|
|an essential feature, especially as both TOAD and PL/SQL developer have it.||10||04-OCT-13|
|As long as it can have a confirmation dialog so accidental edits can't be made. (Maybe with a view SQL statement feature as well)||10||04-OCT-13|
|Apex already exists for this kind of thing. And update statements.||1||20-SEP-13|
|Is an essential feature... Must have||10||19-SEP-13|
|Attempting to convert from PL/SQL Developer and this feature would be great to have.||10||17-SEP-13|
|Very important in the way to substitute TOAD!!!||10||03-SEP-13|
|It is very needed!!!||10||02-AUG-13|
|It is needed!!!||10||30-JUL-13|
|This is very useful information. And Not able to migrate complete to SQL Developer becoz of this feature is not available.||10||22-JUL-13|
|don't wait much longer : )||10||03-JUL-13|
|This feature would be very great to be implemented.||9||22-MAY-13|
|Very useful and necessary feature to have for Developers||10||13-MAY-13|
|Yes please make this feature possible!||10||16-APR-13|
|Very useful feature. When I need to do it, I need to start SQuirreL SQL client. And this is quite often.||10||10-APR-13|
|It is most useful feature and offered in PL/SQL developer and TOAD.||10||28-MAR-13|
|I really don't like Toad for everyday use too heavy. I do very often rely on direct editing so this is indeed a must have.||10||20-MAR-13|