如何进行列间排序

【问题】

could anyone please suggest a way to accomplish this. 
i have a table which consists of six columns : 
Table name : orders 
num1 number, num2 number , num3 number , num4 number , num5 number , num6 number 
there is a routine which fills the data in this table ..but the order of the inserted data is casual. 
my requirement is to create a view over this table in an organized manner > 
example , say this is a row in the table : 
num1 ,num2 , num3 , num4, num5 , num6 
------------------------------------------------------------------------ 
2 7 38 8 19 49 
i need to order content of this row in way i have in the view the data ordered in ascending , so the data should appear in the view in the following way> 
num1 ,num2 , num3 , num4 , num5 , num6 
-------------------------------------------------------------------- 
2 7 8 19 38 49 

【回答】

SQL做这个事很麻烦的，读出来用别的工具好做多了，比如用SPL：

	A
1	$select * from orders
2	=A1.(~.record(~.array().sort()))

A1：从orders表中取数

A2：循环将A1每行记录的字段值通过array函数拼成序列，再通过sort函数排好序，最后通过record函数将每个序列成员当做字段值填入该条记录中

写好的脚本如何在应用程序中调用，可以参考Java 如何调用 SPL 脚本