Oracle Enqueue and locks(Oracle table locks): How it works

Comment
Enqueue and locks

Oracle database is the widely used database in industry .Here I am trying to explains  about oracle locks Topics Covered What is Oracle Enqueue and locks What is Enqueue identifier? What is Enqueue resource? How is the lookup done in Resource table? How is Enqueue operations works? How is the queue checked when lock is release or converted Common Types of Enqueue Views and Table … Continue reading Oracle Enqueue and locks(Oracle table locks): How it works »

MySQL COALESCE and NULLIF Function

Comment

Last updated on October 30th, 2018 at 04:25 amWe will be discussing MySQL COALESCE and NULLIF Function  in this post with lot of examples. COALESCE Function COALESCE Function in Mysql is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent to the following IF-THEN-ELSE statement IF val1 is not NULL THEN … Continue reading MySQL COALESCE and NULLIF Function »

Coalesce Function in Oracle

Comment

Last updated on October 30th, 2018 at 04:28 amCoalesce Function is a useful function in oracle and it is very useful when we want to return first non null values in the list expr1 : This is returned if it is not null expr2: This is returned if it is not null and first expression is null exprn: This is returned if the preceding expression … Continue reading Coalesce Function in Oracle »

NVL2 function in Oracle

Comment

Last updated on October 30th, 2018 at 04:33 amNVL2 function is a nesting function .It examines the first impression, if the the first impression is not null ,then NVL2 function returns the second expression. if the first impression is null, then it return the third expression. expr1: it is the source values or expression which may contain null. You can provide column name,function on the … Continue reading NVL2 function in Oracle »

NVL function in Oracle

Comment

NVL function is a nesting function which is used to substitute null values with certain values In the above syntax expr1 : it is the source values or expression which may contain null. You can provide column name,function on the column name expr2 : It is the target value which will be placed in case null is returned from expr1 If expr1 is null, then … Continue reading NVL function in Oracle »

Update statement in oracle

Comment

Update statement in oracle is used to update the existing rows in the table. It is a DML statement. DML stand data manipulation language. We can use this statement to update specific rows ,set of rows or all rows in the table. Syntax is given below Table : It is the table name which need to be updated column : it is the single column … Continue reading Update statement in oracle »

Unable To Authenticate Session in R12

Comment

Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance ERROR ———————– “Unable to authenticate session” This can happen after the instance is cloned or any changes happened to the system with wrong parameter The first log which you should check in case of this error is $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log Here are some common errors which you might … Continue reading Unable To Authenticate Session in R12 »

Helpful queries for Oracle Apps

Comment

How to compile the package,package body ,procedures alter package <package name > compile; alter package <package name > compile body; alter procedure <procedure name > compile; If it is not successfully compiled, we can look at the errors from the below sql Login to SQL*Plus. SELECT text FROM dba_errors WHERE name = packagename; The output will look something like this. TEXT ——————————————————————— PLS-00302: component ‘XYZ’ … Continue reading Helpful queries for Oracle Apps »

How to assign User management Responsibility to user in R12

Comment

You may need sometimes to assign User management responsibility to the users in EBS R12 Steps to assign the responsibility are Open Define User form Look for the user which need to assigned the responsibility by typing user name in username column and pressing F11 Assign the user management responsibility to the user and Press Save Now User should be  able to see the responsibility … Continue reading How to assign User management Responsibility to user in R12 »

How to install SSH on Ubuntu

Comment

SSH is nice tool to connect to the server. it encrypts all traffic to eliminate eavesdropping, connection hijacking, and other attacks. I will be giving the steps for installing that on Ubuntu OS Step 1: First check if it is already running ps -ef |grep -i SSH Step 2:  Now install the SSH using the command sudo apt-get install openssh-server -y Here are some issue … Continue reading How to install SSH on Ubuntu »