Avatar of Swaminathan K
Swaminathan K
Flag for India

asked on 

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

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
* Oracle12c* Oracle PL/SQLOracle Database

Avatar of undefined
Last Comment
Swaminathan K

8/22/2022 - Mon