PL/SQL Records

Objects of type RECORD are called PL/SQL records PL/SQL records have uniquely named fields, which can belong to different datatypes Define a RECORD type TYPE IS RECORD (fieldname1 : fieldnameN ; (%TYPE and %ROWTYPE can be used to specify ] Example 1 of Record Type…

LOOPS

The ability to repeat or skip sections of a block can be achieved with the usage of LOOP or GOTO statements There are three forms of the LOOP statement – LOOP – WHILE-LOOP – FOR-LOOP LOOP Statement LOOP repeats a sequence of statements Statements to…

Nested Blocks

declare x number; begin x := 80; dbms_output.put_line(‘abc’); declare y number; begin y := 90; dbms_output.put_line(‘Inner Block variable value ‘ || y); end; dbms_output.put_line(‘Outer Block variable value ‘ || x); end; Scope of variables A variable declared in the outer block is accessible in the…

Conditional Statements – IF

The selection structure tests a condition, then executes one sequence of statements instead of another, depending on the condition There are three forms of statements IF-THEN IF-THEN-ELSE IF-THEN-ELSIF Sequence of statements is executed only if the condition evaluates to TRUE If condition evaluates to FALSE…

Programming Basics with PL/SQL

PL/SQL features — PL/SQL is an extension of SQL It is an application development language containing procedural statements and commands along with SQL commands It bridges the gap between database technology and procedural programming languages It allows you to process data using flow control statements…

Oracle , PL/SQL

In recent years, database management systems (DBMS) have established themselves as the primary means of data storage for information systems ranging from large commercial transaction processing applications to PC-based desktop applications. At the heart of most of today’s information systems is a relational database management…

1 4 5 6