Home » SQL & PL/SQL » SQL & PL/SQL » Re: How can I order by the PL/SQL table?
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 ;
Previous Topic: Urgent: Finding the top 10 NET- SALES- FIGURES
Next Topic: How do I create table by select data from another table which has an object assigned to it?
Goto Forum:
  


Current Time: Fri Mar 29 01:28:29 CDT 2024