不知道是不是这个意思
[php]
SQL> set linesize 1000
SQL> select * from t_0001;
OID ATTRVALUE TIME
---------- ---------- ----------------------------------------
8.8002E+13 53110 2008-1-14 16:32:43
8.8002E+13 63310 2008-2-1
8.8002E+13 53810 2008-2-1
8.8002E+13 632632 2008-1-14 17:06:21
8.8002E+13 20 2008-1-16 11:50:13
8.8002E+13 2121 2008-2-1
8.8002E+13 518518 2008-1-14 16:37:17
8.8002E+13 53110 2008-2-1
8.8002E+13 533533 2008-1-14 16:59:10
8.8002E+13 533533 2008-2-1
8.8002E+13 51010 2008-1-14 16:59:56
OID ATTRVALUE TIME
---------- ---------- ----------------------------------------
8.8002E+13 546546 2008-1-14 16:37:45
8.8002E+13 518518 2008-2-1
8.8002E+13 2525 2008-2-1
8.8002E+13 755755 2008-2-1
8.8002E+13 577577 2008-2-1
8.8002E+13 2110 2008-1-14 16:08:53
8.8002E+13 2222 2008-1-14 16:47:15
已选择18行。
SQL> select oid,substr(attrvalue, 1, length(attrvalue) / 2) attrvalue ,time
2 from t_0001
3 where mod(length(attrvalue), 2) = 0
4 and substr(attrvalue, 1, length(attrvalue) / 2) =
5 substr(attrvalue, length(attrvalue) / 2 + 1);
OID ATTRVALUE TIME
---------- -------------------- --------
8.8002E+13 632 2008-1-14 17:06:21
8.8002E+13 21 2008-2-1
8.8002E+13 518 2008-1-14 16:37:17
8.8002E+13 533 2008-1-14 16:59:10
8.8002E+13 533 2008-2-1
8.8002E+13 546 2008-1-14 16:37:45
8.8002E+13 518 2008-2-1
8.8002E+13 25 2008-2-1
8.8002E+13 755 2008-2-1
8.8002E+13 577 2008-2-1
8.8002E+13 22 2008-1-14 16:47:15
---------
[/php]