There is nothing like do while loop in PL/SQL. But you can do the following:
SQL> declare
2 n_num number := 1;
3 begin
4 loop
5 dbms_output.put(n_num||', ');
6 n_num := n_num + 1;
7 exit when n_num > 5;
8 end loop;
9 dbms_output.put_line('Final: '||n_num);
10 end;
11 /
For details visit: http://www.dba-oracle.com/concepts/pl_sql_repeat_until_loop.htm
Subscribe to:
Post Comments (Atom)
Executive Summary: Anthropic's Claude Mythos Model
What Happened Anthropic announced Claude Mythos Preview , a new AI model it describes as its most capable ever — and so powerful in cyber...
-
> dotnet add package Microsoft.SemanticKernel.PromptTemplates.Handlebars --version 1.30.0 using Microsoft . SemanticKernel ; using Micr...
-
Setting up a MPI cluster on Ubuntu involves the following steps: 1. Install OpenMPI on all machines. $sudo apt-get install libopenmpi-de...
-
Finding a session: ------------------ SELECT USERNAME, OSUSER, MACHINE, SID, SERIAL#, STATUS, SECONDS_IN_WAIT from v$session WHERE TYPE != ...
No comments:
Post a Comment