Category "database-cursor"

how to join cursor returned from procedure with other tables in oracle

i have a procedure that give me a refcursor as out parameter and i have to join that data with other tables in my own package. i try to fetch cursor in a variab

Snowflake: Flag infinite loops in hierarchical data without using cursor in Snowflake

I'm struggling with a SQL code performance issue, while trying to identify in advance circular references of a dataset with approximately 1.5 MO rows candidates

How can I get a tablename of a PostgreSQL cursor?

I know that in Oracle we can do something like select * from TABLE(DBMS_XPLAN.DISPLAY_CURSOR('$$SQL_ID')). But there is no sql id field in pg_cursors catalog. W

PL/SQL print out ref cursor returned by a stored procedure

How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the resulting rows to STDOUT in SQL*PLUS? ORACLE stored pro