如何进行列间排序
【问题】
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 脚本
