Shulou(Shulou.com)05/31 Report--

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!

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.