How to use oracle if statement
This article mainly introduces "how to use oracle if sentences". In daily operation, I believe many people have doubts about how to use oracle if sentences. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to use oracle if sentences". Next, please follow the editor to study!
Create or replace procedure findclass2 (num in number)-creates or modifies a stored procedure named findclass
As
TotalClass number (1);-- create a variable of numeric type, totalClass
Begin
If num is not null then
Select count (*) into totalClass from class;-- assign the quantity counted by count to the totalClass variable through into
DBMS_OUTPUT.put_line ('num' | | num);-- number of database outputs
DBMS_OUTPUT.put_line ('totalClass' | | totalClass);-- number of database outputs
If totalClass > = 2 then
DBMS_OUTPUT.put_line ('Total classes' | | totalClass);-- number of database outputs
If totalClass 0 then
DBMS_OUTPUT.put_line ('num is' | | num);-- number of database outputs
Else
DBMS_OUTPUT.put_line ("none of them" | | num);-- number of database outputs
End if
End if
End if
End if
End findclass2;-- the stored procedure ends
Create or replace procedure findclass (num in number)-creates or modifies a stored procedure named findclass
As
TotalClass number (1);-- create a variable of numeric type, totalClass
Begin-- stored procedure start
If num is not null then
Select count (*) into totalClass from class;-- assign the quantity counted by count to the totalClass variable through into
If totalClass > = 2 then
DBMS_OUTPUT.put_line ('Total classes' | | totalClass);-- number of database outputs
End if
If num > 5 then
DBMS_OUTPUT.put_line ('num is' | | num);-- number of database outputs
End if
If num > = 0 then
DBMS_OUTPUT.put_line ('num0 is' | | num);-- number of database outputs
End if
End if
End findclass;-- the stored procedure ends
At this point, the study of "how to use oracle if sentences" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
