A suggestion

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Duke
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

A suggestion

Post by Duke » Tue 23 Oct 2007 08:31

trak wrote:Hi!
I beginner in OraDeveloper and have few suggestions:

1. Explaining plan. When I do click on Explain Plain button OraDev want to create new Plan_Table. But I have system-wide plan_table with public synonym. I do not want to create a new one plan_table on each schema in DB.

2. Transaction. It is not good practicle, to Begin transaction by press a button. I did't find an application-wide set autocommit off or kinda like this.

3. Executions of part of the script. For example I want to execute only part of the script or part of the statement. I did found in documentation, that I must select a fragment of code, then right-click, then select in menu "Execute this" or something. May be possible to execute a statement under cursor by Ctrl-Enter ?

Thank you!
1. We'll take this suggestion into account.
2. By default, OraDeveloper works in autocommit mode. When you press Begin Transaction button autocommit is turned off and you should manually commit transaction.
3. You can customize shortcut for any command including this one. See Options dialog box.
Last edited by Duke on Tue 23 Oct 2007 11:41, edited 1 time in total.

trak
Posts: 6
Joined: Tue 23 Oct 2007 06:50

Post by trak » Tue 23 Oct 2007 09:51

Duke wrote:1. We'll take this suggestion into account.
2. By default, OraDeveloper works in autocommit mode. When you press Begin Transaction button autocommit is turned off and you should manually commit transaction.
3. You can customize shortcut for any command including this one. See Options dialog box.
1. Thank you!
2. I got shoked, when didn't found enabled ROLLBACK button :)
May be it possible to configure OraDev for set autocommit off by default ?

3. Yep, already found. BTW, Cool idea. Thank you!

Post Reply