3 results found
-
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
- Don't see your idea?