Skip to content
← Customer Feedback for Devart

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

(thinking…)

How can we improve the product?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

191 results found

  1. PL/SQL print out ref cursor returned by a stored procedure to GRID tabs

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

  2. Version Control on Script Files for Oracle

    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

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  3. group tab

    1. like groupping SQL editor tab like browers vivaldi , which is helpful to a developer to manage the SQL editor easily.
    2. group result data grip like dbeaver not to run same sql query to get result set again.
    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  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)
    Close
    Close

  4. Excel Export Wrapping Columns Default

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

  5. Excel 2007 Export Null Date Error

    The Excel 2007 export option does not properly handle Null datetime values even if I specify the export format to be string.

    I cannot use the Excel 2007 export option at all because of this issue. If I have a column of type datetime and that column contains NULL values the export will fail with a conversion error.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  6. Excel 97 Headers on Row 11 Export Bug

    Excel export repeats the column headers on row 11 every time

    Every time I export a result set to Excel 97 the first row that contains the column headers is repeated on row 11. This is really damn annoying.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  7. Update data in data editor using rowid

    When I select a table with some column of table and I edit it in grid, Dbforge using another columns to update data, It's seriously bug if these columns not relate what I want update.

    SqlNavigator and more other tool using rowid to update data in grid, can you using that idea to fix this bug.

    Thank you !

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  8. Improve Data Comparison performance during Mapping

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

  9. password reset / expiration

    Other database clients have the capability to deal with an expired password by changing the expired password of the user account, updating the internal stored password, and logging in with the new password through a simple UI.

    Oracle DB Forge Studio does not offer any option to deal with an expired password, an alternative database client seems to be the only answer.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  10. Simple sort of Columns in Query View

    In some schemas/tables there may be MANY fields. It would be fantastic if there were a way to set (and remember) that tables could have their fields sorted alphabetically. It would then be really useful if there was the ability to Filter.

    This second ask would be similar to how part of the Database Explorer works for filtering now.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  11. In Text Editor > Code Completion > Advanced please make "Never" an option for quote identifiers

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

  12. Possibility to connect to DB over proxy

    Possibility to connect to DB over proxy using ssh key for proxy authentication.
    The same thing exists in Oracle SQL developer - SSH hosts, where you can add a list of hosts and attach DBs to them.
    A lot of requests here in features regarding Connections. You could rework this connection window. Add ldap, win auth, ssh connections, proxy, etc. Add folders, organizers, maybe some other useful stuff for connecting to DBs...

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  13. Suggested CODE

    When designing a new table adding fields down at ide is an option that said "Script Changes" and then the software suggests a beautiful code, well it will be cool if that applies for coding to for example a simple drop:
    DROP TABLE ???????????
    Then the suggested code will be something like get this into a transaction as the first feature mentioned.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    under review  ·  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)
    Close
    Close

  14. Formatting CODE

    When autoformat documents the commas go to the beginning of the line and sometimes is a requirement to get trailing commas.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  15. Use existing Metadata while metadata updates

    Every time I start a new connection, I have to wait for the metadata to finish downloading before I can do any query building that requires intellisense to work. I would like the application to use the currently available metadata grabbed from the previous time the software started and then switch to the latest metadata once that process is complete.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    started  ·  1 comment  ·  Questions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. Selecting a word (double click)

    When I select a word (double click), show how many chars are in the selection on the taskbar of dbForge Studio

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  17. data compare

    Data compare

    Please advise if there is another way to achieve this.

    Routinely we compare different schemas with 3000+ data tables. We change the table group we want to compare. Ex:

    (a) Compare these 1000 tables from schema A against schema B.
    (b) Compare these 500 tables from schema A against schema B.

    It is time consuming to select what to compare out of thousands.

    Suggestion would be to have an input list to select source tables to compare with target. An example:

    select tablename from usertables@A X where exists ( select 1 from inputlist
    y where    …

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  18. Spatial Viewer

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

  19. Problem with "Default On NULL"

    I have column definied by:

    AA CHAR(1 CHAR) DEFAULT 'Y' NOT NULL

    I want to check this column with "DEFAULT ON NULL".

    After checking this option in dbForge Studio 2021 4.3.34 column definition changes to:

    AA CHAR(1 CHAR) DEFAULT BY DEFAULT ON NULL 'Y'

    what is incorrect.

    My database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  20. With clause in select statement does not accept functions/procedures

    https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#i2066378

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close
← Previous 1 3 4 5 … 9 10
  • Don't see your idea?