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

84 results found

  1. Add ability to navigate for procedures and functions as it realised in menu item Go To Definition for tables.

    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)
  2. As you see an invalid object, double clicking it, you could go to the object declaration to fix the problem, returning to the invalid object manager after that!

    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)
  3. vi key-bindings in sql editor would be amazing!

    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)
  4. Toad for data point lets you know if you're running a 32 bit or 64 bit version of the software. It would be helpful if studio did the same. Thanks.

    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)
  5. 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)
  6. I'd like to have a spatial viewer tab, like ssms, when geometry objects are part of a result set.

    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)
  7. 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)
  8. I would like to connect AI Assistant with my own ChatGPT account or Github Copilot.

    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)
  9. 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)
  10. A possibility to compare the source code of an object in different schemas, something like an extra option on left mouse over the object tree, "Compare to another schema?" "Compare to external file?". Because compare databases is something unreal.

    2 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)
  11. Then i use query with many param i need write all it into the parameters table hand by hand.

    select :p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10 from dual

    please add textbox what i put m.b. JSON as:
    {p1:1,p2:2,p3:3,p4:4,p5:5,p6:6,p7:7,p8:8,p9:9,p10:10} and it asserted to query and used in execute.
    And can optuinal add type:
    {p1:[1,number],p2:[2,number], p3:3,p4:4,p5:5,p6:6,p7:7,p8:8,p9:9,p10:10} with varchar2 as default

    2 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. All of the following from both the IDE and Command Line
    Schema Export to SQL Files
    Schema Compare of Database to SQL Files
    Generate Create script from SQL Files
    Generate Diff Script from SQL Files
    Deploy Create Script to Database
    Deploy Diff Script to Database
    Commit SQL Files to Git Repo

    2 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  ·  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)
  13. It would be nice if i can select multiple schemas for creating snapshots. "New Schema Comparison" window design is very handy and can be take as an example.

    2 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)
  14. Please either turn off or provide a configuration option to not allow cell wrapping for data exported to Excel.

    Why is this even the default for export when it is not the default for worksheets created in Excel?

    2 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)
  15. The schema comparison should allow to compare DBMS_SCHEDULER-derived objects, such as scheduled jobs, schedules, programs, chains, and so on.

    2 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. It would be great, if I could have an Option for "File per Object" in Schema Export. Similar Option is available in Allroundautomation's PL/SQL Developer (Export User Objects). This would make it easier to track changes of already previously exported UserObject (single) files.

    1 vote
    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. When logging the query execution INCLUDE the Line# of the first line executed in parenthesis. Really useful if you executed a chunk of code.

    Currently:
    -- 6:11:56 PM --
    testUSPNightly_related.sql: Query opened in 0.009s [0.008s exec, 0.001s fetch]

    Suggestion:
    -- 6:11:56 PM --
    testUSPNightly_related.sql (239): Query opened in 0.009s [0.008s exec, 0.001s fetch]

    1 vote
    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)
  18. Is there support for Java codes and classes? The objects are not displayed in Object Viewer.

    1 vote
    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. Hi,
    dbForge posts after an export/import a protocol with number of rows, errors, etc.
    Not listed is the file exported/imported or the used table.
    For those users exporting/importing some tables in parallel this would be helpful!

    Ronald

    1 vote
    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. Add feature to fetch from a ref cursor returned from a stored procedure (OUT variable) and print the resulting rows to GRID tabs.

    Example code to return 2 ref cursors.

    CREATE OR REPLACE PROCEDURE spgetsysdate(c1 IN OUT sysrefcursor, c2 IN OUT sysrefcursor) AS
    BEGIN
    OPEN c1 FOR SELECT SYSDATE FROM dual;
    OPEN c2 FOR SELECT SYSDATE-1 FROM dual;
    END;

    DECLARE
    c1 SYSREFCURSOR;
    c2 SYS
    REFCURSOR;
    BEGIN
    spgetsysdate(c1,c2);
    --How to PRINT c1 and c2 to grid tabs like the DEBUGGER?
    END;

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  • Don't see your idea?