troubleshooting Question

Cursor expressions need to suppress the statement 2 in the query output.

Avatar of sam_2012
sam_2012 asked on
Oracle Database* Oracle PL/SQL* Oracle12c
5 Comments1 Solution28 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros