scott_emp2_cursors.sql

col CURSOR_TYPE for a15
col PROGRAM for a36

select 
  s.program, 
  o.sql_id, 
  o.sql_exec_id, 
  o.cursor_type, 
  o.sql_text
from 
  v$open_cursor o, 
  v$session s
where 
  o.sid = s.sid and
  o.user_name = 'SCOTT' and
  o.sql_id = 'apdcq2s3sxn9y' and
  o.cursor_type like 'OPEN%'
order by 
  o.sql_exec_id, 
  o.cursor_type, 
  s.program
;