Techgoeasy

Simple View of Functions in Shell Script with some practical examples

Shell programming provides the feature of functions just like any other programming language. This helps us develop the program in a modular manner. Using functions in a shell script to perform repetitive tasks is an excellent way to create code reuse. Code reuse is an important part of modern object-oriented programming principles. What are functions in […]

Simple View of Functions in Shell Script with some practical examples Read More »

What is PLSQL records in Oracle

Oracle, Oracle Sql

Oracle PLSQL records PLSQL records are composite datatypes .It is a group of related data items as fields ,each with its own name and datatype. PL/SQL records are similar in structure to a row in a database table. Each scalar data types in the record holds a value. A record consists of components of any

What is PLSQL records in Oracle Read More »

How to use Oracle PLSQL Tables (Associative array or index-by table)

Oracle, Oracle Sql

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 use Oracle PLSQL Tables (Associative array or index-by table) Read More »

How to resolve ORA-00900

Oracle, Oracle Database

ORA-00900 invalid SQL Statement is one of the common errorHere is 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

How to resolve ORA-00900 Read More »

How to create DMZ for EBS R12

Oracle, Oracle Ebuisness Suite

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

How to create DMZ for EBS R12 Read More »

Awesome 24 Concurrent Manager Interview questions

Oracle, Oracle Ebuisness Suite

Here are awesome 24 Concurrent Manager Interview questions asked in most interviews to test concurrent Manager working skills Question 1: What are the different types of concurrent managers? Answer There are several types of concurrent managers. Important ones:Internal ManagerStandard Manager.Conflict Resolution ManagerInternal monitorsService ManagerTransaction ManagerCustom Manager Defined Read more on the below link Oracle Concurrent Manager

Awesome 24 Concurrent Manager Interview questions Read More »