Decline Collector Signed Electronically with airSlate SignNow

Decline collector signed electronically

What’s up Internet? Welcome back once again. I am Manish from RebellionRider.com. Today in this PL/SQL tutorial we will learn the second function in Collection Method Series and that will be EXISTS ( ). Let’s start the tutorial with a quick intro of the collection method EXISTS in Oracle Database. Collection Method EXISTS ( ) checks the existence of an element at a specific index in a collection. If it finds the specified element then it returns TRUE otherwise it returns FALSE. Let’s do an example to understand the concept. SET SERVEROUTPUT ON; DECLARE --Declare a local Nested Table TYPE my_nested_table IS TABLE OF VARCHAR2 (20); So here we have declared a local nested table. This is the same nested table which we created in PL/SQL tutorial 51. Let’s move ahead col_var_1 my_nested_table := my_nested_table('Super Man','Iron Man','Bat Man'); Here we initialized our nested table by inserting three entries using the collection variable col_var_1. So now we have a nested table which has data at the index 1, 2 and 3. Let’s write the execution section. In this section we will see how to use collection method EXISTS to find the existence of the element. BEGIN IF col_var_1.EXISTS (1) THEN DBMS_OUTPUT.PUT_LINE ('Hey we found '||col_var_1(1)); ELSE DBMS_OUTPUT.PUT_LINE ('Sorry, no data at this INDEX'); END IF; END; / Here in this code we are checking if we have anything at index 1 or not. If collection function EXISTS returns true then it will execute the 1st part of the IF ELSE statement and will show the data otherwise it will execute the ELSE part of the IF-ELSE statement. Let’s execute. Here is our result. Before moving ahead let me take a quick second to ask you to Subscribe, if you haven’t already. Also make sure to smash that thumbs up button and like the video. Your every single like means a lot to me and keeps me motivated for doing more such videos. Having said that, now let’s move ahead. That is how you can check the element at a specific index without traversing the whole collection. Along with checking the element at an index you can also take advantage of this function in inserting the data into a cell of a collection and that too without overwriting the already existing data. Suppose you want to insert a data into a specific index but you are not sure whether that index is already holding some data or not. In case if it is holding any then you don’t want to overwrite it. Let’s see how we can do that — But before that let’s close this script output and delete this execution section. Done. BEGIN IF col_var_1.EXISTS(4) THEN DBMS_OUTPUT.PUT_LINE('Hey we found '||col_var_1(4)); ELSE DBMS_OUTPUT.PUT_LINE('This Index is empty. Inserting new Data...'); col_var_1.EXTEND; col_var_1 (4) := 'SpiderMan'; END IF; DBMS_OUTPUT.PUT_LINE('New Data inserted at index 4 is '||col_var_1(4)); END; / In this code we are checking if we have any data stored at index 4 using EXISTS function. If there exists an element at index...