Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Cursors
Is there anyway to print out to the screen from the middle of a cursor.
I know how to do it using SQL Server but I can't seem to do it in Oracle
code included
create or replace procedure DAN
AS
BEGIN
declare
cursor sq_cursor is select * from daily_sales order by sale_qty desc;
sq_val sq_cursor%ROWTYPE;
i INTEGER(5);
begin
open sq_cursor;
for i in 1..10 loop
fetch sq_cursor into sq_val;
/** I WOULD LIKE TO print sq_val.ean_no HERE**/
exit when sq_cursor%NOTFOUND;
end loop;
close sq_cursor;
end;
END;
Received on Thu Aug 19 1999 - 11:57:52 CDT
![]() |
![]() |