View Full Version : SQL procedure
04-16-2011, 11:56 PM
I need some help creating a recursive plsql procedure that will take in an ID and return a SET OF ID'S
04-17-2011, 12:00 AM
The best way to do this is undoubtedly via a stored procedure.
Even better is to rebuild your table with a "path" column that will allow direct queries to find most anything.
04-17-2011, 12:19 AM
yea thats why im asking if anyone can help me create it or show me a similar example. I cant change the table.
04-17-2011, 03:24 AM
Well, this is the MySQL forum, and few (if any) will know PLSQL. You'd be much better off finding an Oracle-specific forum.
I can write in MySQL and SQL Server, but I've never created SPs in Oracle.
Powered by vBulletin® Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. All rights reserved.