Home » SQL & PL/SQL » SQL & PL/SQL » retrieving more than one row
retrieving more than one row [message #35720] Tue, 09 October 2001 22:39 Go to next message
Amira
Messages: 1
Registered: October 2001
Junior Member
Dear Sir

I want to write a PL/SQL program to retrieve the detaials of the employees (notice:more than one row) from the emp table when I entered the department number (deptno) without using a cursor.
Please expedite your answer because I am in need.
I will be grateful if you help me.
Regards

----------------------------------------------------------------------
Re: retrieving more than one row [message #35722 is a reply to message #35720] Wed, 10 October 2001 04:21 Go to previous message
pb
Messages: 18
Registered: December 2000
Junior Member
The following statement will ask for the dept number.

select * from emp
where deptno = &dept;

----------------------------------------------------------------------
Previous Topic: a data conversion question
Next Topic: general clarifications!!urgent
Goto Forum:
  


Current Time: Thu Mar 28 15:24:21 CDT 2024