Re: Inserting rows in SQL Developer
Date: Thu, 4 Sep 2008 09:35:15 +0100
Message-ID: <Ag$uxuGD35vIFwRv@jimsmith.demon.co.uk>
In message <g9mdvc$4uf$1_at_huron.algomas.org>, Álvaro G. Vicario
<alvaroNOSPAMTHANKS_at_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 SmithReceived on Thu Sep 04 2008 - 03:35:15 CDT