PL/SQL triggers are block structures or pre-defined programs, which may be in-built or even explicitly developed by the programmers for a particular task. Triggers are automatically executed when an event occurs which is well thought of by the programmer in advance. Triggers are associated with response-based events such as a Database Definition Language (DDL) statement …
Anonymous class in Java is a class without name. Its name is decided by the compiler. It enables us to declare and instantiate the class at the same time. It is like local class except that it does not have any name. We can use it only once. Anonymous class is also known as anonymous …
Till now we haven’t discussed about the most important commands that provide actual functionality to the batch files, which are none other than file and folder manipulation commands. So, in this post we will be seeing all the commands associated with folder manipulation operations like creating a new folder, how to rename it, display it, …
Whenever you try to execute an SQL statement, Oracle processes it in a separate memory zone called as ‘Context Area’. It contains information regarding information retrieved from database tables/records, SQL query, number of rows accessed by it and many more. This Context Area is controlled by a ‘Cursor’. A PL/SQL cursor can hold one or …
There are two types of PL/SQL blocks: 1. Named Blocks 2. Anonymous Blocks PL/SQL Functions Function is one of the two available Named Blocks in Pl/SQL, the other being Procedure. In PL/SQL, a function takes one or more parameter and returns one value. The main difference between a PL/SQL function and a PL/SQL procedure is …
This is the final post on basic introduction to batch file programming. So, we will wind up the topics and see some practical applications of batch files. We basically know till now that batch files can be used to automate the tasks such as opening your favorite links all at once, automatically cleaning your computer, …
A subprogram is a module or a small unit/part of a program that performs a particular task. In modular programming, a program can optionally consist of multiple subprograms. Note: A schema level subprogram is a standalone subprogram. PL/SQL Procedure A procedure is a group of PL/SQL statements that you can call by its name. These …
There may arise a situation when you need to execute a particular block of code several number of times. Programming languages provide various control structures that allow for more complicated execution paths and Loops are one of them. In other words, you may sometimes need to run a particular block of code in the program …
