Oracle PLSQL Tables PLSQL tables are composite datatypes. These behave in the same way as arrays except that have no upper bounds, allowing them to constantly extend. They are also called index by table PLSQL Table contains two elements (1) A primary key of BINARY_INTEGER datatypes that index the table, which do not need to […]
how to check trigger status in oracle
Trigger are important construct in oracle . These are the codes which are fired when a row is updated ,inserted or deleted in the oracle table. Lets find how to check trigger status in oracle, how to check trigger definition in oracle, How to find all Trigger in the table and many more How to […]
How to resolve ORA-00900
ORA-00900 invalid SQL Statement is one of the common errorHere what oracle documentation says about this error Reference: Oracle documentation Checklist to solve the ORA-00900 invalid SQL Statement (1) This error commonly occurs when you are trying to create an Oracle procedure and the Procedural Option is not installed.To determine if the Procedural Option has […]
How to create DMZ for EBS R12
This post I will explaining my experience with setting up DMZ for EBS R12. We will first go through some of the important terms DMZ The DMZ, which stands for Demilitarized Zone consists of the portions of a corporate network that are between the corporate intranet and the Internet. The DMZ can be a simple […]
Awesome 24 Concurrent Manager Interview questions
Here are awesome 24 Concurrent Manager Interview questions asked in most interview to test concurrent Manager working skills Question 1: What are different types of concurrent manager? Answer There are several types of concurrent manager. Important ones:Internal ManagerStandard Manager.Conflict Resolution ManagerInternal monitorsService ManagerTransaction ManagerCustom Manager Defined Read more on below link Oracle Concurrent Manager Question 2: […]
What is Oracle PLSQL Variables
Oracle PLSQL Variable 1) Variables and constants must be declared for use in procedural and SQL code, although the datatypes available in SQL are only a subset of those available in PL/SQL. 2) All variables and constants must be declared before they are referenced. 3) Remember that each variable must be declared on a separate […]
