188 results found

1. Support User Objects Types as parameters of procedures, functions or queries in Edit Parameters dialog
   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  ·  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

2. Make row number column always visible in Data Editor despite scrolling horizontal scroll bar
   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  ·  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

3. 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

4. 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

5. 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

6. 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

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

8. 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