OraFAQ Forum: SQL & PL/SQL » how to replace rank() function in pl/sql

Home » SQL & PL/SQL » SQL & PL/SQL » how to replace rank() function in pl/sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to replace rank() function in pl/sql [message #43434]

Thu, 17 July 2003 22:07

soy
Messages: 6
Registered: July 2003

Junior Member

I have sql queries that use Rank() quite a bit. These are select queries that return mulitple rows (based on if the rank = 1 or 2 or whatever). Now when I try and use Rank() in pl/sql (Oracle 8i) it doesn't work since it isn't supported. What can I do to get around this limitation?

Report message to a moderator

Re: how to replace rank() function in pl/sql [message #43435 is a reply to message #43434]

Fri, 18 July 2003 00:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

1. Use NDS (Native Dynamic SQL) to pass the select directly to the SQL engine.

2. Create an alternative select.

MHE

Report message to a moderator

Re: how to replace rank() function in pl/sql [message #43438 is a reply to message #43435]

Fri, 18 July 2003 15:42

soy
Messages: 6
Registered: July 2003

Junior Member

take a look at this thread too please:
http://www.orafaq.net/msgboard/newbies/messages/9790.htm

Report message to a moderator

Previous Topic:	Comparing Null in WHERE Clause
Next Topic:	How would I do this?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 08 04:14:25 CDT 2025