Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the alternative for 'for loop' ?

kalyan vedagiriJul 7 2021 — edited Jul 7 2021

i want to update the table by using a decrementor and row id as below.
my_line_count := 0;
select count(*) into my_line_count from emp where empno = in_empno
For line_rec in ( select rowid from emp where empno = in_empno order by countline desc)
loop
update emp set countline = my_line_count where ROWID = line_rec.ROWID;
my_line_count = my_line_count -1;
end loop;
This procedure will be called for suppose 314 times, by another procedure( based on count in emp table i:e for each row);

Before data is like
select countline from emp where empno = in_empno ;
countline
1
1
1
1
1
-- so on

Expected result
select countline from emp where empno = in_empno ; (For exapmle there are 314 rows)
countline
314
313
312
311
.
.
.
3
2
1

Is there any way to perform above logic without loop?

Comments

802316
You can send any type of data through JMS, however you have to connect to its broker to receive messages.

I don't know of any mail viewer which supports JMS, so you would need to create a gateway which receives JMS messages and sends them via an SMTP to a service your mail client is connected to.
YoungWinston
870564 wrote:
we are trying to send mail through jms (Java message service) but showing this msg. we are not receiving any mail which is sent through JMS
Sending Mail Message to queue on 2011-07-06
Message send to jms queue successfully."
You'll need to provide a LOT more information than that if you want a definitive answer. Have a look [url http://mindprod.com/jgloss/sscce.html]here.

Winston
1 - 2

Post Details

Added on Jul 7 2021
9 comments
1,416 views