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 脚本