FROM keyword not found where expected

[misuk11]

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


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 Spencer]

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:

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