83 results found
-
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?