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:
HTHCode: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
John




Reply With Quote