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

190 results found

  1. 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  ·  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. 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)
  3. "Compile" button for packages and procedures

    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)
  4. It looks like you support GIT in other product within the company, and it would be very helpful for Sudio for Oracle to do as well.

    63 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)
  5. 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)
  6. Add visual editor for Oracle database settings

    2 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)
  7. I'd like to be able to create a folder(s) in the Database Explorer Window based on a filter. For example...
    Create a folder named Customer Tables. The folders contents are based on the filter "table_name like 'CUST%'".
    Maybe even mix object types so I can see all customer tables and stored procedures.

    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)
  8. If 1=1 then
    if 1=2
    then end
    if 1-1=1
    then
    begin

    end
    else
    else
    if 1=3 then else
    end if;
    end if;

    To easy find errors in similar code. I think code this error is not format automatically.

    7 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)
  9. Reports allow to add C# scripting for specific events. This is a great feature, but the editor used to write c# is really poor, basic. No intellisense, no indentation, etc...
    I think it could be great to use a better editor.
    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)
  10. 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  ·  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. This is especially important if you are copying query results into Excel. You would normally want the absence of values to appear as blanks, rather than appear to be a value called "(null)".

    5 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)
  12. It would be helpful to generate C# POCO sourcecode right inside dbForge Studio.

    Right click on table or view => Generate script as => C# POCO

    I use code first approach, but structure changes are made directly in the database.
    Of course I use VS if I have to create a complete new c# model from a database. But for single tables / views it would be a timesaver, to generatet the POCO C# sourcecode in dbForge and then copy-paste it to VS (especially with Oracle).

    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. When editing a table with a column that has an Identity specification, set the initial value to the max value of the existing data in the identity column plus the increment so that PK Constraints aren't triggered on subsequent insert. Possibly prompt to perform this?

    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. 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)
  15. 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.

    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. 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)
  17. Group multiple database connections into single tree node in Database Explorer. Eg.

    Database Explorer

    [+] Environment 1
    [-] Environment 2
    [+] DB Connection 1
    [+] DB Connection 2
    [-] Environment 3
    [+] DB Connection 3
    [+] DB Connection 4

    109 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)
  18. When i double click on a table should exist a tab that shows a model diagram of the selected table and his relations (Primary Key and Secondary Key) to other tables.
    That way i can quickly visualize the connections between the table i selected and his relatives.
    This functionality already exist in Oracle's SqlDeveloper.

    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. Currently only the text of an SQL statement seems to be copied (CTRL+C). It would be great if the formatting could be retained. This way the formatted text could be inserted e.g. into Word for documentation purposes.

    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. 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)
  • Don't see your idea?