Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
We 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 val1 ELSIF val2 is not NULL THEN val2 … Continue reading MySQL COALESCE and NULLIF Function
Coalesce 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 are null So Coalesce function will return first … Continue reading Coalesce Function in Oracle
This is very useful function .It compare two values and return null if the values are same , else return the first value expr1 : it is the source values or expression which is going to be compared with expr2 expr2 : It is also the source value which is compared with expr1 You cannot specify the literal NULL for the first value SQL> select … Continue reading NULLIF function in Oracle
NVL2 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 column name expr2: This is the value of … Continue reading NVL2 function in Oracle
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 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 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
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
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
Delete from table statement is used in Sql to delete the rows in the table. It is a DML (Data Manipulation language) statement. It is used to delete the subset of existing rows or all existing rows from the table. we will looking at Oracle Sql syntax but this is valid for sql’s Here is the syntax Here table is the table name and condition … Continue reading Delete from table statement in Oracle
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
These are 35 Most Useful command to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on the server. I have included command for all major Linux distribution like CentOS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS or dedicated server b) Choose SSH or telnet … Continue reading 35 Useful command to help you manage the VPS or Dedicated Server