Even or odd pl/sql program

Asked 11 months ago. Active 11 months ago. Viewed times. Improve this question. Hi there. It looks like rather than wanting the result of a simple division, you want the "remainder" on doing the division.

You should learn that indentation can provide a lot to the readibility of your code! Add a comment. Active Oldest Votes. Improve this answer. Thanks a lot SteveLovell. I didn't check the code properly. As you can se in the syntax above, we can have multiple elsif statements with as many conditions as we want. Below we have a diagram or we can say a flowchart:. Below we have a program to find whether the two given numbers are equal and if they are not equal then which one is greater.

If we try to describe the case statement in one line then, then we can say means " one out of many ". It is a decision making statement that selects only one option out of the multiple available options. It uses a selector for this purpose. This selector can be a variable, function or procedure that returns some value and on the basis of the result one of the case statements is executed.

If all the cases fail then the else case is executed. In the above program, mod function is used which will return the remainder after dividing the value of a by 2. The remainder will be either 0 or 1, based on that the selected case will be executed. In this type of case statement, no selector is used but a test condition is checked by using the WHEN clause itself.

And if all the test conditions gets failed then the else case is executed. Learn CSS. Learn JavaScript. C Language C Tutorial. C Compiler. Standard Template Library. Python Python Tutorial. Python Programs. Python How Tos. Numpy Module. Matplotlib Module. Tkinter Module. Network Programming with Python. Learn Web Scraping. More in Python Python Compiler. Java Core Java Tutorial. For the location of the directory, see the Oracle installation or user's guide for your system.

Here is a list of the files and their locations in this guide:. Batch Transaction Processing". Calling a Stored Procedure". You can experiment with the samples from any Oracle account. Before trying the samples, you must create some database tables, then load the tables with data.

The first script builds the database tables processed by the sample programs. The second script loads or reloads the database tables.

The following example uses a simple FOR loop to insert ten rows into a database table. The values of a loop index, counter variable, and either of two character strings are inserted. Which string is inserted depends on the value of the loop index.

The following example uses a cursor to select the five highest paid employees from the emp table. The following example illustrates block structure and scope rules.

An outer block declares two variables named x and counter and loops four times. Inside this loop is a sub-block that also declares a variable named x. The values inserted into the temp table show that the two x 's are indeed different.