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