dbTalk Databases Forums  

Inserting rows in SQL Developer

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Inserting rows in SQL Developer in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Inserting rows in SQL Developer - 09-03-2008 , 11:28 AM






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
--

Reply With Quote
  #2  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: Inserting rows in SQL Developer - 09-04-2008 , 06:15 AM






Jim Smith escribió:
Quote:
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
--


Reply With Quote
  #3  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: Inserting rows in SQL Developer - 09-04-2008 , 06:15 AM



Jim Smith escribió:
Quote:
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
--


Reply With Quote
  #4  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: Inserting rows in SQL Developer - 09-04-2008 , 06:15 AM



Jim Smith escribió:
Quote:
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
--


Reply With Quote
  #5  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: Inserting rows in SQL Developer - 09-04-2008 , 06:15 AM



Jim Smith escribió:
Quote:
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
--


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.