Hi Team ,
Iam using a cursor expression in my query . In the query output I need to exclude the CURSOR STATEMENT : 2 statement fron the output and show only the column values . Any help is really appreciated.
Executive CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
FIRST_NAME
--------------------
Steven
Neena
Lex
Finance CURSOR STATEMENT : 2
CURSOR STATEMENT : 2
FIRST_NAME
--------------------
Nancy
Daniel
John%
Ismael
Jose Manuel
Luis
6 rows selected.
Query :
SELECT
d.department_name ,
cursor (select first_name from employees e where e.department_id=d.department_id) employeeInfo
from departments d
Our community of experts have been thoroughly vetted for their expertise and industry experience.