Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    38

    Unanswered: Any Restriction on the use of analytic select?

    Hi.

    We are trying to build a cursor using the analytic functions (partition by and then group by ). But we couldnt compile the procedure. Is there any restriction on the use of analytic functions. Like shd not use in the cursor definition...etc. Please throw some light...

    Thnx & regards,
    avr

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Any Restriction on the use of analytic select?

    Sounds like you are using 8i, where analytic functions are available in SQL but not in PL/SQL. PL/SQL has always lagged behind SQL in the adoption of new features. Work-arounds include creating a view to hide the use of analytic functions, or dynamic SQL.

Posting Permissions

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