An exception is a condition which executes when an error occurs during execution of a PL/SQL program. PL/SQL provides a feature that lets the programmers to handle these exceptions in the exception block in a PL/SQL program. Exception block contains the methods (defined by the programmer) which can provide a particular action that needs to …
Here are 50+ frequently asked PL/SQL interview questions and answers which will definitely help you out to crack one of the toughest interviews. Q1. How can you Rollback a particular part of a procedure or any PL/SQL Program? It can be done using Savepoints during definition of a PL/SQL program. Q2. Is there …
Java decompiler is a tool which is designed in such a way that it is capable of converting .class file into Java source code. It will not give the exact java source code from which the .class file is generated but most of the code will be same. Decompiler is really helpful in case you …
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 …
