how to replace the null value with charecter value('no data") and how to identify which column having the null value this code write in procedure

Hi

You can also do that by using this query

Select COALESCE(CountryName,'No Data') As CountryName, COALESCE(StateName,'No Data') As StateName From EmployeeTable

Hi User,

You can use the NVL function in Oracle SQL to check the existance of NULL values.

But i want Identify which column having the null value:

SELECT *
  FROM TABLENAME
 WHERE columname IS NULL;

To replace the Null data using NVL function:

Example Query:

SELECT empno, NVL (LASTNAME, 'No Data')
  FROM EMP;

Thanks,
Shankar

Hi Ramesh

You can check this by 2 ways and they are either

Select ISNULL(CountryName,'No Data') As CountryName, ISNULL(StateName,'No Data') As StateName From EmployeeTable

OR 

Select CASE WHEN CountryName IS NULL THEN 'No Data' Else CountryName END AS CountryName, CASE WHEN StateName IS NULL THEN 'No Data' Else StateName End AS StateName From EmployeeTable