192 results found

1. Implement sequence re-creation in visual editor to allow Intial value to be changed
   2 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Hide Unused Features Within Object Hierarchy

   Suppose for most tasks, I will only be using [CURRENTUSERSCHEMA_NAME] and [SYS]. Within each of them I do NOT need Packages, Procedures, Functions, User Types, Materialized Views/Logs, Synonyms, Clusters, Database Links and XML Schemas. dbForge should have a global user preference to hide unused options.

   11 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. expression indexes

   Normal view for expression indexes

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. Execute script after connect

   Perform script (file) executing after connect to project

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. add text convertes in import/export data (substring,trim,ltrim,rtrim), for exmaple.

   send a 50 varchar column to another table with 40 colum varchar, in pl/sql there is a option to make this with a part of command in textbox (substr(:xxxxxx,1,4o) ... it's generated in insert

   3 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. Hide connection name in object explorer optionaly

   the ability to hide the connection name in object explorer

   5 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

7. Edition-Based Redefinition

   https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS020

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. Support nanoseconds in Data Editor

   The query:
   SELECT TO_TIMESTAMP('2001-01-11 20:05:44.123456789', 'yyyy-mm-dd hh24:mi:ss.ff') FROM dual

   being executed in dbForge Studio for Oracle, returns:
   2001-01-11 08:05:44.123456

   The three digits of the fraction are lost.

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

9. Ability to generate reusable schema synchronization script

   Sometimes you need to update a database with the synchronization script generated when comparing two schemas. However, this script will not always be executed against the schema used for generating this script (the developer has run the comparison between the earlier and present schema, generated the script and sent it out to the administrators of the customer, for example). Locally, the earlier schema has been manually modified and, as a result, the updating script executed only partially and the rest produced errors. After some changes, there appears a need to execute it again, whereas the first part of the changes was already applied and will now lead to the errors in the log.

   Or, let's review another case. The updating script is included into an installation package (updating the software and the database). Let's assume that something is broken in the program. To repair this, the installation package was run once again. It's preferrable that the database updating script would "understand" that there is no need to do anything in the database (all is done already), would work out silently with no errors and that's all.

   In that regard, there is a need to manually adapt the updating synchronization scripts with the purpose to make it reusable (i.e., you can execute it as many times as you want and this wouldn't produce errors).

   For example, instead of:

   ALTER TABLE HR.JOBS ADD MAX_SALARY NUMBER(6);

   you can write the following construction:

   BEGIN
   BEGIN
   EXECUTE IMMEDIATE 'ALTER TABLE HR.JOBS ADD MAX_SALARY NUMBER(6)';
   EXCEPTION WHEN OTHERS THEN
   IF SQLCODE <> -1430 THEN --NOT "column being added already exists in
   table"
   RAISE;
   END IF;
   END;
   END;

   I.e., if the error arises due to the fact the field was already created, it needs to be ignored. If the error differs from this, it needs to be shown as usual in order to mask out all possible errors. And so on, the same principle with index creation, deletion, etc. So, it would be great if there was some "reuse" option when generating the updating synchronization script that would generate similar constructions to the shown above. The suggested solution may be not optimal and, may be, you have to check if the object exists before creating/deleting it by referring to the corresponding view and then decide if something needs to be done or not, rather than process the error.

   Obviously, the implementation wouldn't be that simple (there may be many different ways in practice). However, if it could be implemented, it would be really an advantage over PL/SQL Developer, TOAD and any other competitors.

   Sometimes you need to update a database with the synchronization script generated when comparing two schemas. However, this script will not always be executed against the schema used for generating this script (the developer has run the comparison between the earlier and present schema, generated the script and sent it out to the administrators of the customer, for example). Locally, the earlier schema has been manually modified and, as a result, the updating script executed only partially and the rest produced errors. After some changes, there appears a need to execute it again, whereas the first part of the changes… more

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

10. Itemize IO according to each step in plan of Query Profiler

    The main reason the tool was considered by my company was its SQL profiling feature. My company is currently looking for a tool to assist with SQL query performance and tuning. The SQL Profiling feature only captures IO metrics at the query level. It does not itemize the IO according to each step in the plan.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

11. Automate creation of triggers with sequence for autoincrement

    Automate creation of triggers with sequence for autoincrement like in Toad.

    Example:

    CREATE OR REPLACE TRIGGER STATUSTRG
    BEFORE INSERT
    ON TDR.STATUS
    REFERENCING NEW AS New OLD AS Old
    FOR EACH ROW
    BEGIN
    -- For Toad: Highlight column ID
    :new.ID := TDR.STATUSSEQ.nextval;
    END STATUS_TRG;
    /

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

12. Do not open stored procedure definition upon execution

    Whenever I execute a procedure it opens automatically in an editor, is it possible to disable this or simply stop opening, if I really did want it opened it is simple enough..

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating