Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Toad, you can use

edit tablename where ...

and then simply edit the data in DB. Is there any equivalent in Oracle SQL developer?

share|improve this question

No, but you can double click on the table name and and then edit it

enter image description here

Note: you should also be able to edit the data from the data grid shown in the SQL Worksheet but I haven't confirmed that

share|improve this answer

Ctrl + Mouse hover over the table or view name, that will open up Table Editor and you can edit the field values.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.