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

Thread: Can you use rank() -- analytics inside PL/SQL?

  1. 03-15-2002, 05:58 PM #1
    bberg@rtnyc.com
    bberg@rtnyc.com is offline Member
    Join Date
    Jul 2000
    Posts
    105
    Is the work around to use dynamic sql, and put the rank inside the statement?
    Reply With Quote Reply With Quote
  2. 03-15-2002, 06:14 PM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, prior to 9i the only option for using analytical functions in PL/SQL is to use dynamic sql (NDS or DBMS_SQL).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width