There are two types of exceptions in PL/SQL Built-in Exceptions and User-Defined Exceptions. Built-in exceptions are predefined in Oracle with a exception (error code) and its details. User Defined exceptions…
CSVeda Posts
PL/SQL Exception is a run-time error caused due to many things that occur in a database application. It can be due to wrong data stored in variables, incorrect data accessed…
ASP.NET framework provides an interface in the form of an Integrated Development Environment to create and execute web applications. A Web Application is a dynamic website made up of multiple…
A cursor named and declared in a PL/SQL block’s declare section is called an Explicit Cursor. The explicit cursors must be declared, opened, fetched and closed. The management of PL/SQL…
All the cursors declared by PL/SQL for SQL statements of a PL/SQL block are called Implicit Cursors. A programmer doesn’t need to write Open, Fetch and Close operations to manage…
An array is a collection of elements of same data type. VB.NET Control Array is an array whole elements are VB.NET controls of same type. In this post you will…
PL/SQL cursors are internal data structures used to execute SQL statements. SELECT statements in PL/SQL programs are implicit cursors. They represent memory areas used by SQL processor to execute SQL…
PL/SQL Iterative control statements allow a programmer to execute a set of statements multiple times. All iterative statements must have a conditional statement to check whether to continue to execute…
Like any procedural programming language, PL/SQL programs can also using Branching structures to control flow of logic. The conditional or branching statements of PL/SQL are IF-THEN-END IF IF-THEN-ELSE-END IF IF-THEN-ELSIF-END…
Programming in PL/SQL requires you to understand the existence and availability of declared variables for correct coding. PL/SQL variable scope and visibility lets you understand where and when the variables…