191 results found
-
excel export with sql code in one cell
When export to excel (and some others) add empty sheet named "Code" and paste full query SQL text on this sheet.
1 vote -
DISPLAY OF DATE WITH TIME AND WITHOUT TIME
While executing select query In TOAD the data in date columns are displayed dynamically. If time is stored along with the date, it will show the date with time. Else it will show only date.
In DBForge, the date field is displayed always with the time component. If I remove the time format in settings, it will always show without time.
Is there a setting to achieve the TOAD functionality?
Thank You
1 vote -
Frozen Columns
It would be good to have the possibility to freeze columns in the grid in the data edit, like in this example.
https://docs.devexpress.com/WPF/6302/contr
ols-and-libraries/data-grid/grid-view-data-layout/columns-and-card-fields/fixed-columns-and-bands1 vote -
Duplicate Objects enhancements
We would like to see expanded ability to duplicate objects. Right now can only do tables and views, but would like to see that expanded to packages, procedures etc.
Would also like the ability to copy to a different server and database. Right now, limited to duplicating to a different schema on the same connection.
Using the schema synchronization takes too long to compare schemas that have a lot of objects, when only one object needs to be synchronized from test to prod.
1 vote -
include .DDL File extension
Dear Sirs,
We have .SQL and .DDL files. The latter is used with all of our create statements.Unfortunately, when I open a .DDL file, you do not treat it as SQL!
You have a TON of other file extensions. Can we add this one? And have it behave like .sql does?
Is this a case where if we assigned it in windows, or changed a registry it could fix it?
1 vote -
1 vote
-
Problem with "Default On NULL"
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 -
data compare
Data compare
Please advise if there is another way to achieve this.
Routinely we compare different schemas with 3000+ data tables. We change the table group we want to compare. Ex:
(a) Compare these 1000 tables from schema A against schema B.
(b) Compare these 500 tables from schema A against schema B.It is time consuming to select what to compare out of thousands.
Suggestion would be to have an input list to select source tables to compare with target. An example:
select tablename from usertables@A X where exists ( select 1 from inputlist
y where…1 vote -
Formatting CODE
When autoformat documents the commas go to the beginning of the line and sometimes is a requirement to get trailing commas.
1 vote -
Possibility to connect to DB over proxy
Possibility to connect to DB over proxy using ssh key for proxy authentication.
The same thing exists in Oracle SQL developer - SSH hosts, where you can add a list of hosts and attach DBs to them.
A lot of requests here in features regarding Connections. You could rework this connection window. Add ldap, win auth, ssh connections, proxy, etc. Add folders, organizers, maybe some other useful stuff for connecting to DBs...1 vote -
Version Control on Script Files for Oracle
All of the following from both the IDE and Command Line
Schema Export to SQL Files
Schema Compare of Database to SQL Files
Generate Create script from SQL Files
Generate Diff Script from SQL Files
Deploy Create Script to Database
Deploy Diff Script to Database
Commit SQL Files to Git Repo1 vote -
DDL for tables with Automatic partitioning
Extracting DDL for a table with Automatic partitioning fails to add "AUTOMATIC" keyword. E.Q.
PARTITION BY LIST ("CAR_ID") AUTOMATIC
1 vote -
CURSOR support
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 voteWe will fix this issue in one of the next product builds and will notify you once it’s available for downloading.
-
Suggested CODE
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 -
group tab
- like groupping SQL editor tab like browers vivaldi , which is helpful to a developer to manage the SQL editor easily.
- group result data grip like dbeaver not to run same sql query to get result set again.
1 vote -
PL/SQL print out ref cursor returned by a stored procedure to GRID tabs
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 SYSREFCURSOR;
BEGIN
spgetsysdate(c1,c2);
--How to PRINT c1 and c2 to grid tabs like the DEBUGGER?
END;1 vote -
Use existing Metadata while metadata updates
Every time I start a new connection, I have to wait for the metadata to finish downloading before I can do any query building that requires intellisense to work. I would like the application to use the currently available metadata grabbed from the previous time the software started and then switch to the latest metadata once that process is complete.
1 vote -
Make turning off the 'Prefix object names with a schema name' option work for generating CREATE TABLE statements
this option appears non-working when using regular CREATE statement (Generate Script As -> Create).
0 votes -
Command Window to develop and execute SQL scripts
The Command Window can be used to develop and execute SQL scripts, using the familiar SQLPLus command syntax. The built-in editor should be a comfortable environment to develop scripts, using SQLPlus, SQL and PL/SQL syntax highlighting. It should have the same powerful features as the PL/SQL Editor, such as the code completion, quick info, and so on. You can quickly switch between the script editor and the command line by clicking on the tabs at the top of the window.
Just like with SQL*Plus you can interactively type single commands and SQL statements on the command line. Error…
0 votes -
Make Code Completion understand @ and suggest database links
Code Completion should understand @ and suggest database links, for instance:
SELECT * FROM EMP@-> should suggest database links
0 votes
- Don't see your idea?