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

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