When I insert some new rows in SQL Developer's data grid (or I edit
existing fields), there doesn't seem to be any way of submitting changes
except doing a COMMIT.

Is is possible to edit data as you do in TOAD with the autocommit option
disabled? That is:

1. Edit data in the grid
2. Play with it, possibly writing queries in other windows
3. When done, COMMIT or ROLLBACK


I couldn't find anything relevant in the help browser.

(There's a SQL Developer forum in Oracle site but it seems to be down
most of the time.)


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--

In message <g9mdvc$4uf$1@huron.algomas.org>, Álvaro G. Vicario
<alvaroNOSPAMTHANKS@demogracia.com> writes
>When I insert some new rows in SQL Developer's data grid (or I edit
>existing fields), there doesn't seem to be any way of submitting
>changes except doing a COMMIT.
>
>Is is possible to edit data as you do in TOAD with the autocommit
>option disabled? That is:
>
>1. Edit data in the grid
>2. Play with it, possibly writing queries in other windows
>3. When done, COMMIT or ROLLBACK
>
>
>I couldn't find anything relevant in the help browser.
>
>(There's a SQL Developer forum in Oracle site but it seems to be down
>most of the time.)
>
>

Assuming you have the latest version, there is a 'Post edits on row
change' option which might do what you want. Tools|Preferences
|Database|ObjectViewer Parameters.
--
Jim Smith

Jim Smith escribió:
>> Is is possible to edit data as you do in TOAD with the autocommit
>> option disabled? That is:
>>
>> 1. Edit data in the grid
>> 2. Play with it, possibly writing queries in other windows
>> 3. When done, COMMIT or ROLLBACK

> Assuming you have the latest version, there is a 'Post edits on row
> change' option which might do what you want. Tools|Preferences
> |Database|ObjectViewer Parameters.

That's exactly the option, thank you very much. Searching for "commit"
in the Preferences search box doesn't return that page, I suppose it
only searches in the tree...


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--