Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    2

    Unanswered: ORA-00923 From Keyword Not Found

    Hello,
    I am trying to add 3 blank columns to the end of my query and i'm receiving the ORA-00923 error. Any idea how I can fix this error? The query runs just fine when I delete the 3 blank columns at the end of the query but I need to include these 3 blank columns.

    select (RPAD(NVL(C.EMPLOYEE_ID, ' '), 3, ' ') ||
    ' '||
    RPAD(NVL(C.EMPLOYEE_NAME, ' '), 10, ' ') ||
    ' '||
    RPAD(NVL(C.EMPLOYEE_EMAIL, ' '), 30, ' '))
    ' '||
    ' '||
    ' '||
    FROM exmployee_data C
    ORDER BY C.employee_name

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what get concatenated to the right end line above the FROM clause?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2011
    Posts
    2
    Nothing. I set that up to create a blank column (3 char).

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Nothing. I set that up to create a blank column (3 char).
    Then why have the trailing "||" on this line?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Is this a parser benchmark or is there any other reason for right-padding with blanks and then concatenate more blanks ?
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •