GET_COLUMN_VALUE 和 ROWNUM < 400 什么意思 ？

[ttaallkk1]

SELECT A.BACK_CONFECT_NO_FLAG,
A.PROD_ORDER_ID,
A.ORDER_MAX_SEQ,
A.APP_NO,
A.NEW_SERV_GUID,
A.NEW_PROD_ID,
A.OLD_SERV_GUID,
A.OLD_PROD_ID,
A.SERVICE_OFFER_ID,
A.ACTION_ID,
A.PROD_ORDER_DERIVE,
A.EXEC_ORDER_ID,
A.WORKFLOW_INST_ID,
TO_CHAR(A.CREATE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS CREATE_DATE,
A.STATE,
TO_CHAR(A.STATE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS STATE_DATE,
A.REGION_ID,
A.CANT_CANCEL_FLAG,
TO_CHAR(A.FIRST_PRE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS FIRST_PRE_DATE,
TO_CHAR(A.SECOND_PRE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS SECOND_PRE_DATE,
TO_CHAR(A.THIRD_PRE_DATE, 'YYYY-MM-DD HH24:MI:SS') AS THIRD_PRE_DATE,
A.ARCHIVES_CODE,
A.STAFF_ID,
A.ORG_ID,
A.NOTE,
A.PAY_FLAG,
A.ACCEPT_REASON,
A.OLD_PRODUCT_TYPE,
A.OLD_ABS_PROD_ID,
A.DISMANTLE_REASON_ID,
B.ACTION_NAME AS ACTION_NAME,
GET_OBJECT_NAME(A.NEW_PROD_ID) AS PRODUCT_NAME,
D.BILLING_NO AS BILLING_NO,
D.PRODUCT_ID AS PRODUCT_ID,A.NEW_SERV_GUID,A.OLD_SERV_GUID,
GET_COLUMN_VALUE(D.SEL_NUM_LEVEL) AS NUM_LEVEL_COLVALUE,
D.SERV_ID

FROM
TBM_PRODUCT_ORDER_ASK A,
ACTION B,
SERV_ASK D

WHERE A.ACTION_ID = B.ACTION_ID
AND A.NEW_SERV_GUID = D.SERV_GUID
AND GET_COLUMN_VALUE(A.STATE) != '8'
AND ROWNUM < 400

以上sql语句中 GET_COLUMN_VALUE（）什么意思？
ROWNUM < 400 什么意思？
谢谢
给除纤细的例子和讲解 谢谢

[wiler]

ROWNUM < 400
这个应该是ROWNUM < 400吧，因为<经过HTML翻译后就是"<"号
rownum是查询结果集的行号，rownum<400则是取查询结果集的前399行

[wiler]

GET_COLUMN_VALUE应该是用户自定义函数，我没见过oracle用过这个函数，呵呵