PL SQL Case Statement | IF-THEN-ELSIF Statement in PL/SQL | PL-SQL Full Course Tutorial 2023 | PT

"PL SQL Case Statement | IF-THEN-ELSIF Statement in PL/SQL | PL-SQL Full Course Tutorial 2023 #sqlcasestatement #sqlif #sqlthen #sqlelse #sqlifthen #sqlifthenelse #sqlelseif #plsql #sqlendif #dbms #oraclesql #plsqltutorial #plsqltutorialinenglish #PLSQL #plsqlforbeginners #plsqlbasics #plsqlprocedures #plsqlcursor #plsqlfunctions #plsqltriggers #plsqlvssql #oracleplsql #PLSQLtutorialforbeginners #PLSQLtutorialinenglish #plsqlinterview #plsqlinenglish #parnikatutorials #plsql2023 #plsqlfullcourse2023 #plsqlfullcrashcourse2023 #plsqlcrashcourse #plsqlcourse2023 previous video link - IF-THEN-ELSE Statement in PL/SQL | Conditional Statements in Pl/SQL | PL-SQL Full Course https://youtu.be/rrTZQDeWjTc?list=PL4x0v29DZ2pATvhl00brjnebF2GbzzTOj 00:38 - IF-THEN-ELSIF Statement explaination 04:37 - examples by using sqlplus output 09:36 - Case statement in plsql " In this video, I have discussed IF-THEN-ELSIF and Case Statement in Pl/SQL #plsql #parnikatutorials #dbms #oraclesql The IF-THEN-ELSIF statement allows you to choose between several alternatives. An IF-THEN statement can be followed by an optional ELSIF...ELSE statement. The ELSIF clause lets you add additional conditions. When using IF-THEN-ELSIF statements there are a few points to keep in mind. It's ELSIF, not ELSEIF. An IF-THEN statement can have zero or one ELSE's and it must come after any ELSIF's. An IF-THEN statement can have zero to many ELSIF's and they must come before the ELSE. Once an ELSIF succeeds, none of the remaining ELSIF's or ELSE's will be tested. Syntax The syntax of an IF-THEN-ELSIF Statement in PL/SQL programming language is − IF(boolean_expression 1)THEN S1; -- Executes when the boolean expression 1 is true ELSIF( boolean_expression 2) THEN S2; -- Executes when the boolean expression 2 is true ELSIF( boolean_expression 3) THEN S3; -- Executes when the boolean expression 3 is true ELSE S4; -- executes when the none of the above condition is true END IF; Case Statement: Like the IF statement, the CASE statement selects one sequence of statements to execute. However, to select the sequence, the CASE statement uses a selector rather than multiple Boolean expressions. A selector is an expression, the value of which is used to select one of several alternatives. Syntax The syntax for the case statement in PL/SQL is − CASE selector WHEN 'value1' THEN S1; WHEN 'value2' THEN S2; WHEN 'value3' THEN S3; ... ELSE Sn; -- default case END CASE; Social media Links: Instagram: https://www.instagram.com/parnikatutorials/ Website: http://parnikatutorials.in/ Email id: [email protected] To get the regular updates: Telegram link: https://t.me/Parnikatutorials Facebook: https://m.facebook.com/profile.php?id=109245950811428&ref=content_filter Linkedin: https://www.linkedin.com/in/parnika-tutorials-a8a9831b2/ Pinterest: https://in.pinterest.com/parnikatutorials0892/ Playlists: Virtual Coffee with Jagadeesh: https://youtube.com/playlist?list=PL4x0v29DZ2pArePUk30o6Twn7sqnqbYCH Digital Logic Design: https://youtube.com/playlist?list=PL4x0v29DZ2pA2ZmL3dclnA-HfHkFAy0GI Computer Organization and Architecture: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBRd8bChJJFtTn6ClJhKzfZ C Programming: https://www.youtube.com/watch?v=h9LtX_R-7uA&list=PL4x0v29DZ2pAIQdtRr-1zaYnqGiD_fU0M Data Structures: https://www.youtube.com/watch?v=m51BGPXdPAQ&list=PL4x0v29DZ2pCtKml6NNoBhYK4K_QnsCA_ Theory of Computation: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pDq-5SI9KlYxPDKdYCcmgJm Compiler Design: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBsF-lPUHQ_8uRy-LbDSHIH Operating Systems: https://www.youtube.com/watch?v=vCCmq8hTC8Y&list=PL4x0v29DZ2pD6MzSQMIDSawLSKUZTFfxE Databases: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pCYEa9s3r5zWrFYIxGivlEC Computer Networks: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBBOq-QsHtCuA53IlRxIQNm For GATE PYQs and much more explore: https://www.youtube.com/c/ParnikaTutorials/playlists