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

79 results found

  1. 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)
    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)
    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)
  2. 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)
    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)
  3. 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)
  4. 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)
    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)
  5. 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)
    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)
  6. 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)
    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)
  7. 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)
    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)
  8. 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)
    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)
  9. 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)
    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. 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)
  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. Dear Sirs,
    We have .SQL and .DDL files. The latter is used with all of our create statements.

    Unfortunately, when I open a .DDL file, you do not treat it as SQL!

    You have a TON of other file extensions. Can we add this one? And have it behave like .sql does?

    Is this a case where if we assigned it in windows, or changed a registry it could fix it?

    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)
  13. We would like to see expanded ability to duplicate objects. Right now can only do tables and views, but would like to see that expanded to packages, procedures etc.

    Would also like the ability to copy to a different server and database. Right now, limited to duplicating to a different schema on the same connection.

    Using the schema synchronization takes too long to compare schemas that have a lot of objects, when only one object needs to be synchronized from test to prod.

    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)
  14. It would be good to have the possibility to freeze columns in the grid in the data edit, like in this example.

    https://docs.devexpress.com/WPF/6302/contr
    ols-and-libraries/data-grid/grid-view-data-layout/columns-and-card-fields/fixed-columns-and-bands

    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)
  15. While executing select query In TOAD the data in date columns are displayed dynamically. If time is stored along with the date, it will show the date with time. Else it will show only date.

    In DBForge, the date field is displayed always with the time component. If I remove the time format in settings, it will always show without time.

    Is there a setting to achieve the TOAD functionality?

    Thank You

    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)
  16. When export to excel (and some others) add empty sheet named "Code" and paste full query SQL text on this sheet.

    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. it would be a great feature to have the possibility to pass values in "where" filter as parameters while running comparisons from the command line:

    datacompare.com /datacompare /compfile:"D:\mycompdoc.dcomp" /param:<par1>,<val1>[;<par2>,<val2>;...]

    and in mycompdoc.dcomp we have

    ...
    <Object SourceName="MyTable" TargetName="MyTable" SourceType="Table"
    TargetType="Table"> <SourceFilter>MyCol in (0,@par1,@par2)</SourceFilter>
    </Object>
    ...

    42 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)
  18. When creating a connection, it would be great if I could select a default object and folder to open. For example: When I connect to a database, I have to select show all objects. I than need to select my desired Schema and than select the Tables folder to view the tables. I have to do this every time I disconnect and reconnect. It would be great to be able to select this as a default to do it automatically every time I connect.

    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. 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)
← Previous 1 3 4
  • Don't see your idea?