84 results found
-
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 dualbeing executed in dbForge Studio for Oracle, returns:
2001-01-11 08:05:44.123456The three digits of the fraction are lost.
0 votes -
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 -
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 -
0 votes
- Don't see your idea?