Hello everyone,
I would like to take the values from one plsql table, sort and store them into another plsql table, without using sql types.
How can i achieve this?
set serveroutput on;
DECLARE
TYPE file_array_ty IS TABLE OF number index by binary_integer;
file_array file_array_ty;
file_array2 file_array_ty;
BEGIN
file_array(1):=1;
file_array(2):=0;
file_array(3):=3;
file_array(4):=2;
/*
your suggestion code
*/
dbms_output.put_line(file_array2(1));
dbms_output.put_line(file_array2(2));
dbms_output.put_line(file_array2(3));
dbms_output.put_line(file_array2(4));
END;
output should be
0
1
2
3