FROM keyword not found where expected

Where did you learn to use PL/SQL assignment operators to alias column names??? :rolleyes:

Code:

---

select id, description,
        NVL(prog_flag,      'N') prog_flag,
        NVL(movie_flag,    'N') movie_flag,
        NVL(prod_co_flag, 'N') prod_co_flag,
        NVL(common_flag, 'N') common_flag,
        app_seq, prog_seq, movie_seq
  from billings_contrib_types
order by app_seq;

---

Tha's an odd mix of SQL and PL/SQL. I assume you are trying to alias the NVL'ed columns. If so you need to do it like:

Code:

---

SELECT id, description, NVL(prog_flag, 'N') prog_flag,
      NVL(movie_flag, 'N') movie_flag, NVL(prod_co_flag, 'N') prod_co_flag,
      NVL(common_flag, 'N') common_flag, app_seq, prog_seq, movie_seq
FROM billings_contrib_types
ORDER BY app_seq

---

HTH
John