记录内值排序

记录内值排序

【问题】

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	=connect("test")
2	=A1.query("select * from arangeRow")
3	=A2.(~.record(~.array().sort()))

A1: 连接数据库。

A2：查询源表。

A3：根据 A2 每条记录转换成数组重排，再填回去。

A2

A2