DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: FROM keyword not found where expected

Hybrid View

  1. #1
    Join Date
    Jul 2005
    Posts
    23

    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.

  2. #2
    Join Date
    May 2005
    Location
    Toronto Canada
    Posts
    57
    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
  •  


Click Here to Expand Forum to Full Width