[PL/SQL] Basic PL/SQL Oracle Report 6i

Deskripsi
     Basic Syntax dari PL/SQL cocok untuk programmer yang ingin membuat report menggunakan Oracle Report 6i.

Howto
// Basic Syntax
Declare
    -- your variable
begin
    -- your statement
end;


// Basic Variable
       myvar varchar (20);


// basic variable constant 
      myvar varchar (20) := 10;


// Basic Function
function ZZZ return Char is
    -- your variable without declare
begin
   -- your statement
end;


// Conditional Statement
 IF kondisi1 THEN 
     --xxx

ELSE 

    --yyy

   IF kondisi2 THEN 

        --fff

    END IF; 

    ELSIF kondisi3 THEN 

       --hhh

    END IF;

// Loop Statement

For cnt IN 1..10

     -- statement

END LOOP;

While condition1

     -- statement

END LOOP;