Re: How can I order by the PL/SQL table? [message #39302] |
Thu, 04 July 2002 06:09 |
Devang Pandya
Messages: 9 Registered: June 2002
|
Junior Member |
|
|
How can I order by a PL/SQL table?
e.g.
DECLARE
lcl_output_array DBMS_SQL.varchar2_table ;
BEGIN
-- Basically I'm converting an array from JAVa to a PL/SQL table.
-- lcl_output_array has the value in following way:
-- lcl_output_array(1001) := 'Product Type'
-- lcl_output_array(1002) := '2' -- these represents product id
-- lcl_output_array(1003) := '100'-- value for input paramater
-- lcl_output_array(1004) := '1' -- This is the priority and i want to order by this value
-- lcl_output_array(2001) := 'Product Type'
-- lcl_output_array(2002) := '3' -- these represents product id
-- lcl_output_array(2003) := '10'-- value for input paramater
-- lcl_output_array(2004) := '2' -- This is the priority and i want to order by this value
-- lcl_output_array(3001) := 'Product Type'
-- lcl_output_array(3002) := '1' -- these represents product id
-- lcl_output_array(3003) := '10'-- value for input paramater
-- lcl_output_array(3004) := '3' -- This is the priority and i want to order by this value
END ;
|
|
|