-
FROM keyword not found where expected
Where did you learn to use PL/SQL assignment operators to alias column names???
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;
Last edited by gandolf989; 07-26-2005 at 11:27 AM.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|