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 …
Decision-Making is an important part for most of the computer programs. It helps to develop the program code logically. For correct decision making, PL/SQL provides us with the Conditional Statements. These Conditional Statements helps us to develop a proper algorithm and a logical program. Decision-making programs or structures require that the developer mentions conditions to …
Till now all the tutorials are the basics that you need to start with batch files. From now, we are going to jump into some fascinating real world applications and some important commands that makes using your Windows PC much easier and comfortable than ever. We will also peep through how to build these scripts, …
Innovation and expertise at the latest tools have become two of the most prominent points of concern among web designers and developers. If you’re a creative individual, then you need a suitable instrument for being able to produce a web product that is beyond boundaries in terms of looks and functionality. Although you might be …
