In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Record the use of exit and return
Exit is used to jump out of the loop
Loop
IF V_KBP IS NULL THEN
EXIT
END IF
End loop
Return jumps out of stored procedure
Loop
IF V_KBP IS NULL THEN
Return
END IF
End loop
Jump out of the loop primary cycle
Continue is available in oracle 11g
Oracle 10g and below, using goto instead, for example
SQL > set serveroutput on
SQL > declare
2 begin
3 for i in 1..10 loop
4 if mod (iQuery 2) = 0 then
5 goto next
6 end if
7 dbms_output.put_line (I)
eight
9 null
10 end loop
11 end
12 /
Note: the null; statement after the tag is indispensable, because the goto tag must be followed by an execution statement.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.