I am trying to return empty or dummy string if select query returns `null`.I tried using dummy value in `NVL(colum,'dummy')`, but I am still getting `no data found` error.
Below is what I tried:

**1.** 

```
  SELECT de.destination INTO l_sub_ent

  FROM dest de

  where de.destination='somevalue' AND de.destination IS NOT NULL; 

```

**2.** 

```
  SELECT COALSECE(de.destination, 'dummy') INTO l_sub_ent

  FROM dest de

  where de.destination ='some value'; 

```

**3.**

```
  SELECT NVL(de.desc_en, 'dummy') INTO l_sub_ent

  FROM dest de

  where de.destination ='some value'; 

```