Unanswered: Any Restriction on the use of analytic select?
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...
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.