Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    13

    Unanswered: can't execute query with PERCENTILE_DISC

    I am using oracle 8i enteprise edition ver 8.1.6
    I'm trying to execute the query below:

    SELECT PERCENTILE_DISC (0.5) WITHIN GROUP (ORDER BY a.time_duration) AS kkk
    FROM v_user_time_duration a

    and I get this error:
    ora-00923:from keyword not found were expected.

    what is the problem ?
    oracle in this version can execute that query?

    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm afraid your DB version is too low ... this analytic function is added in Oracle9i.
    Last edited by Littlefoot; 08-10-04 at 05:21.

Posting Permissions

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