Скачать или смотреть Troubleshooting Your PL/SQL Code: Fixing If-Then-Else Statements

Struggling with `PL/SQL` if-then-else statements? Discover how to resolve common errors efficiently and enhance your coding skills!
---
This video is based on the question https://stackoverflow.com/q/66904167/ asked by the user 'SITANSHU YADAV' ( https://stackoverflow.com/u/12632621/ ) and on the answer https://stackoverflow.com/a/66904259/ provided by the user 'Gregorio Palamà' ( https://stackoverflow.com/u/4274223/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: PL/SQL if then else statements not running

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Troubleshooting Your PL/SQL Code: Fixing If-Then-Else Statements

When coding in PL/SQL, it’s not uncommon to run into syntax errors that can halt your project’s progress. One such challenge can arise within your if-then-else statements, which may result in confusing error messages. Recently, a programmer faced the issue of their if-then-else code not executing correctly, leading to an error message that read: Error at line 35: PLS-00103: Encountered the symbol ";" when expecting one of the following. Let’s dissect this problem and uncover how to resolve it swiftly.

The Problem Explained

In the provided PL/SQL code, we have a procedure named sorting_criteria that aims to sort a list of products based on specified criteria. The procedure accepts a string parameter criteria, which defines whether the products should be sorted by the lowest or highest price. However, the error arises due to improper syntax in the if-then-else statements.

The Original Code (with Issues)

[[See Video to Reveal this Text or Code Snippet]]

The key issue here is the usage of else if which is incorrect in PL/SQL. Instead, it should be written as ELSIF. Not addressing this leads to the compiler misunderstanding your intentions, causing a syntax error.

The Solution: Fixing the Syntax

Step 1: Replace else if with ELSIF

To fix the problem, simply change the else if to ELSIF. Here’s how the correction looks in your code:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Ensure Proper Closure of Blocks

This corrected code maintains the proper structure of the code blocks, ensuring each condition is well-managed under the cooperative BEGIN and END keywords. Each IF statement concludes with an END IF;, ensuring clarity in scope and logic flow.

Conclusion

Flags like PLS-00103 can be tricky, especially if you're not familiar with the syntax rules of PL/SQL. By replacing else if with ELSIF, you can resolve the syntax error and run your procedure successfully. With attention to detail in syntax, you're one step closer to mastering PL/SQL and enhancing your programming skills.

So, the next time you encounter a puzzling error in your code, revisit the syntax rules and refactor as needed. Happy coding!