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

----------------------------------------------------------------------

Report message to a moderator

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;

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 20 03:00:09 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.