Skip to content

dbForge Studio for Oracle

dbForge Studio for Oracle is a powerful Oracle database development environment that provides you versatile data editing tools for managing in-database and external data. It allows you to synchronize data between different Oracle servers and automate schema change management process during development.

http://www.devart.com/dbforge/oracle/studio/

dbForge Studio for Oracle

Categories

JUMP TO ANOTHER FORUM

191 results found

  1. To have possibility to write debug messages like there:

    BEGIN EXECUTE IMMEDIATE 'ALTER TABLE SomeTable MODIFY SomeField VARCHAR2(200) NULL';
    EXCEPTION WHEN OTHERS THEN dbmsoutput.putline(SQLCODE);
    END;

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. It would be nice it there is a shortcout to open direct a selected Table from a Script.

    For example:

    Create table xy as select from t_test;

    So i can go with the cursor to ttest and with a shortcut the table ttest opens directly (Data View)

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Implement numbered bookmarks that can be set using the keyboard shortcut Ctrl-Shift-number

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. When I use dbForge to interactively alter tables, the execution hangs the system such that nothing can be done within dbForge while the change occurs. If I copy the sql code to a sql window and execute the code myself then it doesn't hang the system.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. When comparing a small number of tables across different databases in a cloud deployment for large schemas that are not of our design, Data Comparison performs poorly in the transition from Options to Mapping. In some cases, it exceeds the allowed timeout for schemas with thousands of objects in both the source and target.

    Observationally, even if the Optional "include" filter mask is used, Data Comparison is describing all data objects in both schemas. The only thing actually filtered is the result set displayed in the Mapping.

    It would therefore seem simple to limit the objects enumerated and described in…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. There are often times when performing navigation with the Go To Definition (F12) command in the package. It would be great if there was a possibility to have the history of such navigations and to navigate back in the navigations chain.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. I have to work with a failover connection string on my customer. So always he change to other connection I have to change it on my dbForge db configuration. On SQL Developer from Oracle, what is not so nice to work with like dbForge, I can add an connection string looking like this:

    jdbc:oracle:thin:@(DESCRIPTION = (ADDRESSLIST = (FAILOVER = ON) (LOADBALANCE = OFF) (ADDRESS = (PROTOCOL = TCP)(HOST = porasbbmgmscan.server.com)(PORT = 1551)) (ADDRESS = (PROTOCOL = TCP)(HOST = dorasbbmgmscan.server.com)(PORT = 1551))) (CONNECTDATA = (SERVICENAME = DB_SNAPSHOT)))

    It wold by very helpful for me, if I can…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. For procedures/functions - navigate to their definitions in the package body.

    For tables - navigate to Table Editor.

    For views - navigate to the view's data.
    etc.

    This functionality is present in most IDEs. Why not implement it here?

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. When solving a specified task, you need to work with some group of DB objects such as tables, packages, etc.

    I would prefer to have the ability to collect them all together in one node of the tree in Database Explorer.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. Add ability to filter tables based on LIKE syntax and BETWEEN syntax.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Data editor allows customization of the order and column width, set sorting and filtering records, also set how the text is highlighted (HTML, XML, …).
    After a restart of the application, this setting is lost.
    I mean the possibility of persistent individual customization for each table or view.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. The tool is adding quotes where they are not needed (for instance if x is a %rowtype and you type x.a it will become x."a" which is not needed).

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. When creating a where clause in query builder have an option that shows the possible values for a field (select one for logical checks, checkboxes for in and not in selections). This was one of the nice features in TOAD.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Export current result set as insert statement to file and to clipboard (how is it in toad). Quick preview of the selected object (like F4 in Toad).

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Support for UNION operator in Query Builder

    It's not always convenient to have many Views created in the database, when UNION can be used to join these in a single view.

    Query builder does not support UNION at this time and it would be a nice addition.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Normal view for expression indexes

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. New feature: Hide some columns in all table diagrams with a specific names defined by the user. For example: "TIMESTAMP", "LASTUSER" , etc. In some cases all tables owns some of theese fields that are not important in the diagrams and wastes space.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Add to Database Explorer the ability to view the list of the private procedures/functions in package body. Otherwise, there is no possibility to navigate to the functions that are not specified in the package declaration.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Sorting! Just "must be" feature.

    Ability to search connection by typing in "LIKE '%searchstring%" algorythm.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?