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

  1. Fusion doesn't play well with SSDT in the same solution. Fusion grabs all .sql file associations. Double click on a .sql file in Sql Server Database Project and Fusion prompts you for a connection to Oracle. The only way to get the file loaded into SSDT Designer is to right click the file. This could all be solved if DevArt tokenized the file extension and allowed the user to choose: .plsql.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    When installing dbForge Fusion, it becomes the default editor for opening *.sql files and you are asked to select a connection in the dbForge Fusion’s dialog. Though, you can change the default editor in the ‘Open With’ dialog of Visual Studio. For this, please perform the following:

    1. Select ‘File → Open File…’ from the main menu of Visual Studio. The ‘Open File’ dialog opens.
    2. Select a *.sql file and click the down-arrow against the ‘Open’ button.
    3. Select ‘Open With…’.
    4. Select an editor and click ‘Set as Default’.
    5. Click ‘OK’.

  2. Extracting DDL for a table with Automatic partitioning fails to add "AUTOMATIC" keyword. E.Q.

    PARTITION BY LIST ("CAR_ID") AUTOMATIC

    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  ·  0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  3. SELECT CURSOR( SELECT * FROM dual ) FROM dual;
    Returns ORA-01001: invalid cursor
    On second try to open cell, the app crashes.
    Other tools let you explorer contents of cursor.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Forget about caching metadata. This is the biggest foolishness I ever saw.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. If you start the search in one window and then attempt to search the same word in another document, the search will be running in the initial window instead of the active one. With this, the focus will switch to the initial window.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  6. Data in global temporary tables not showing in data explorer of table, but in query like "select * from some_gtt" all data is visible. Version of DB Forge Studio is 4.0.237

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Tooltip hinders when clicking on the tabs panel.

    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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?