PL/SQL Functions What is a Function in PL/SQL? A function is a named PL/SQL Block which is similar to a procedure. The major difference between a procedure and a function is, a function must always return a value, but a procedure may or may not return a value. General Syntax to create a...

Read More

PLSQL Stored Procedures

Stored Procedures What is a Stored Procedure?A stored procedure or in simple a proc is a named PL/SQL block which performs one or more specific task. This is similar to a procedure in other programming languages.A procedure has a header and a body. The header consists of the name of the procedure...

Read More

Explicit Cursors

Explicit Cursors An explicit cursor is defined in the declaration section of the PL/SQL Block. It is created on a SELECT Statement which returns more than one row. We can provide a suitable name for the cursor.General Syntax for creating a cursor is as given below: CURSOR cursor_name...

Read More

Cursors In Pl/Sql

Cursors In Pl/Sql What are Cursors? A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. This temporary work area is used to store the data...

Read More

Iterative Statements in PL/SQL

Iterative Statements in PL/SQL Iterative control Statements are used when we want to repeat the execution of one or more statements for specified number of times. There are three types of loops in PL/SQL: • Simple Loop • While Loop • For Loop 1) Simple Loop A Simple Loop is used...

Read More

Conditional Statements in PL/SQL

Conditional Statements in PL/SQL As the name implies, PL/SQL supports programming language features like conditional statements, iterative statements.The programming constructs are similar to how you use in programming languages like Java and C++.In this section I will provide you syntax...

Read More

PL/SQL Records

PL/SQL Records What are records?Records are another type of datatypes which oracle allows to be defined as a placeholder. Records are composite datatypes, which means it is a combination of different scalar datatypes like char, varchar, number etc. Each scalar data types in the record holds...

Read More

PL/SQL Constants

PL/SQL Constants As the name implies a constant is a value used in a PL/SQL Block that remains unchanged throughout the program. A constant is a user-defined literal value. You can declare a constant and use it instead of actual value. For example: If you want to write a program which...

Read More

PL/SQL Variables

                        PL/SQL Variables PL/SQL Placeholders Placeholders are temporary storage area. Placeholders can be any of Variables, Constants and Records. Oracle defines placeholders to store data temporarily,...

Read More

Advantages of PL/SQL

Advantages of PL/SQL These are the Advantages of PL/SQL Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or a logical module. PL/SQL Blocks can be stored in the database and reused. Procedural Language Capability:...

Read More

Oracle Master-Details forms for beginners

Creating a Master/Detail FormIn this section, the basic steps for creating a Master/Detail form are introduced. A Master/Detail form is a form that has two blocks arranged in a master/detail relationship.The Master/Detail RelationshipThe Master/Detail relationship is a common relationship between...

Read More

Oracle report for beginners

Create a report using wizard in Report Builder.Open Report BuilderThis is the first screen you will see. Select the first option “Use the Report Wizard” and click OK.Click NextEnter Report Title: erpschools_sample_report and then select “Tabular” option.As per name “Tabular” our output will be organized...

Read More