Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Pl/sql Conditional Control: IF statementsFrequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statements conditionally. That is, whether the series is executed or not depends on the value of the condition. There are 3 forms of IF statements: IF-THEN, IF-THEN-ELSE, & IF-THEN-ELSIF.IF-THENThe simplest form of the IF statement acquaintances a condition with a series of statements enclosed by the keywords THEN and END IF (not ENDIF), as shown below:IF condition THENsequence_of_statementsEND IF;The series of statements is executed only if the condition is true. When the condition is false or null, then the IF statement can do nothing. In either of the case, the control passes to the next statement. An illustration is shown below:IF sales > quota THENcompute_bonus(empid);UPDATE payroll SET pay = pay + bonus WHERE empno = emp_id;END IF;You may want to place brief IF statements on a single line, as inIF x > y THEN high := x; END IF;IF-THEN-ELSEThe IF statement that is the second form adds the keyword ELSE follow by an alternative series of statements is as shown below:IF condition THENsequence_of_statements1ELSEsequence_of_statements2END IF;The series of statements in the ELSE clause is executed only if the condition is false or null. Therefore, the ELSE clause ensure that a sequence of statements is executed. In the example below, the first UPDATE statement is executed if the condition is true, while the second UPDATE statement is executed if the condition is false or null:IF trans_type = ’CR’ THENUPDATE accounts SET balance = balance + credit WHERE...ELSEUPDATE accounts SET balance = balance - debit WHERE...END IF;The THEN and ELSE clauses can involve the IF statements. That is, the IF statements can be nested, as the example below shows:IF trans_type = ’CR’ THENUPDATE accounts SET balance = balance + credit WHERE...ELSEIF new_balance >= minimum_balance THENUPDATE accounts SET balance = balance - debit WHERE ...ELSERAISE insufficient_funds;END IF;END IF;IF-THEN-ELSIFAt many times you want to select an action from some mutually exclusive alternatives. The third form of the IF statement uses the keyword ELSIF to introduce the additional conditions which is as shown below:IF condition1 THENsequence_of_statements1ELSIF condition2 THENsequence_of_statements2ELSEsequence_of_statements3END IF;When the first condition is false or null, then the ELSIF clause tests another condition. An IF statement can have a few number of ELSIF clauses; the final ELSE clause is elective. The Conditions are evaluated one by one from top to bottom. When any condition is true, its related sequence of statements is executed and the control passes to the next statement. If all the conditions are false or null, then the sequence in the ELSE clause is executed. Consider the following illustration as shown below:BEGIN...IF sales > 50000 THENbonus := 1500;ELSIF sales > 35000 THENbonus := 500;ELSEbonus := 100;END IF;INSERT INTO payroll VALUES (emp_id, bonus, ...);END;When the value of sales is bigger than 50000, the first and second conditions are true.However, bonus is assigned the proper value of 1500 as the second condition is never tested. When the first condition is true, its related statement is executed and the control passes to the INSERT statement.
Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage
Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th
SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE
Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho
Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi
Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL
Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_
Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative
Datatypes Every constant and variable has a datatype that specifies the storage format, constraints, and the valid range of values. The PL/SQL gives a variety of predefined dat
Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd