Oracle PL/SQL Case Statement
Oracle PL/SQL provides case statement control which is used in decision making. It has similarities with the IF statement control of PL/SQL. In case statement there is a selector,
ReadOracle PL/SQL Conditions
Controlling the flow of execution is common in programming. It is very much needed to direct the flow of program based on some conditions. This can be done in any programming language by IF statements.
ReadOracle PL/SQL Blocks
PL/SQL is a block structured language. Everything written in PL/SQL are divided in logical blocks. Each blocks has three parts declaration sections, executable sections and exception handling sections.
ReadBank Reconciliation
A company's cash account records all the transactions related to cash. Similarly Bank also records all the transactions of its account. The balance of these two account should be equal. But in most cases they don't match properly.
ReadInheritance (OOP)
Inheritance is the process of acquiring the properties and functionalities of another class. An object is a container that contains properties and methods to operate of these properties.
ReadEncapsulation (OOP)
Encapsulation is the process that binds data and functions which operates on the data under a single entity. It is one of the most important four features of Object Oriented Programming.
Read