|
|
-
|
|
CONTINUE statement
Introduce in Oracle 11g,this statement provides an easy way to force an immediate jump to the loop control statement
Let us see this into action by writing a simple Even..Odd number program
SQL> BEGIN
2 FOR i IN 1 .. 10 LOOP
3 IF MOD(i,2) = 0 THEN
4 ......
|
|
-
|
|
Let Us Learn Oracle - Part 41 of N [ Cume_Dist function of Oracle ]
It acts both as Aggregate and analytic function.
Analytic Example
Purpose: Within a group of rows, it calculates the cumulative distribution of a value in a group of values.
Syntax: Cume_Dist() Over ([partition_by_clause] ord......
|
|
-
|
|
Let Us Learn Oracle - Part 30 of N [ VSize function of Oracle ]
Purpose: It returns the number of bytes in the internal representation of expression. If expression is null, it returns null.
SQL> Select EMPNAME, VSize(EMPNAME) VSizeExample
2 From tblemployee;
EMPNAME ......
|
|
-
|
|
EXIT statement
EXIT statement is similar to the BREAK statement found in other programing languages like C, C++, Java, C# , JavaScript, SQL SERVER etc.
It breaks the loop statement once the specified condition becomes true and then control comes to the statement immediately following the loop
S......
|
|
-
|
|
Begin
2 DBMS_OUTPUT.PUT_LINE('The result is : ' || Addition(10,20));
3 End;
4 /
The result is : 30
PL/SQL procedure successfully completed.
Example 2: Overlo......
|
|
-
|
|
SubTypes in PL/SQL
Purpose:These are user defined types based on other data types.It gives an alternate name to the existing type
Syntax: SUBTYPE IS
Let us look into some example. Let us write a program to find the factorial of a number.This time we will accept the number at runtime.
DECLAR......
|
|
-
|
|
Oracle Associative Arrays Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article wil......
|
|
-
|
|
Oracle Nested Table Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article will focu......
|
|
-
|
|
Oracle VARRAY Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article will focus on V......
|
|
-
|
|
EndValue;
END LOOp;
DBMS_OUTPUT.PUT_LINE('Sum of even Numb......
|
|