Saturday, 26 July 2014

undefined undefined
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...
undefined undefined
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...
undefined undefined
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...

Saturday, 12 July 2014

undefined undefined
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...
undefined undefined
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...
undefined undefined
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...

Wednesday, 9 July 2014

undefined undefined
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...
undefined undefined
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...

Tuesday, 8 July 2014

undefined undefined
                        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,...
undefined undefined
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:...

Monday, 7 July 2014

undefined undefined
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...
undefined undefined
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...
Copyright © 2025 ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com